I'm testing out the Metabase with my MongoDb instance and am experiencing an issue with grouping.
For example, if I attempt to select all records grouping by CPU_BrandString which is a "type/Text"
It appears to be grouping the data correctly, and returning the proper counts, but the values of those entries are null.
The native query is:
[{"$project":{"Data___UserSystem___CPU_BrandString":"$Data.UserSystem.CPU_BrandString","Data___UserSystem":"$Data.UserSystem"}},{"$project":{"_id":"$_id","___group":{"Data___UserSystem___CPU_BrandString":"$Data___UserSystem___CPU_BrandString"}}},{"$group":{"_id":"$___group","count":{"$sum":1}}},{"$sort":{"_id":1}},{"$project":{"_id":false,"count":true,"Data___UserSystem___CPU_BrandString":"$_id.Data___UserSystem___CPU_BrandString"}},{"$sort":{"Data___UserSystem___CPU_BrandString":1}}]
But in the database, there are clearly values attached.
Any suggestions?
Thank you.