is there a way to unfold the nested json? tutorial said it that you have to switch on Unfold JSON, but I can't find the switch. I pressume it's because the field is not JSON, but as we all know, mongodb is a JSON (BSON) by nature.. so how to unfold the json when using mongodb?
JSON unfolding is actually enabled by default in MongoDB. You can use any nested JSON field in filters, summaries, custom columns etc. Metabase will generally display JSON fields unfolded into columns as well, but there's currently a bug with display settings where if you select to display *all* the fields in the document, the nested fields will not unfold. The workaround is to uncheck any one field from the field selector in the query builder editor (the downward error next to the collection name in the "data" block) - as long it's not "select all", then the nested JSON fields will unfold into columns as well. This issue is on our radar and we're working on it!
is there a way to unfold the nested json? tutorial said it that you have to switch on Unfold JSON, but I can't find the switch. I pressume it's because the field is not JSON, but as we all know, mongodb is a JSON (BSON) by nature.. so how to unfold the json when using mongodb?
JSON unfolding is actually enabled by default in MongoDB. You can use any nested JSON field in filters, summaries, custom columns etc. Metabase will generally display JSON fields unfolded into columns as well, but there's currently a bug with display settings where if you select to display *all* the fields in the document, the nested fields will not unfold. The workaround is to uncheck any one field from the field selector in the query builder editor (the downward error next to the collection name in the "data" block) - as long it's not "select all", then the nested JSON fields will unfold into columns as well. This issue is on our radar and we're working on it!