Hi Metabase Team, How can i count distinct "id" in mongodb in metabase platform.
when i am using $count function it is giving error to me :-
$group:
{
_id: null,
sku_count: {$count : "sku"}
}
Please suggest me what would be the right syntax if i just want to count without any filter condition.
@oshimmahajan I don't know what sku() is. Perhaps you'll find better help in a Mongo specific forum, since Metabase does not have such function, so you would need to do it in Native query.
Hi @flamber , I am facing issue in filtering of Metabase-MongoDB .
This is user interactive filter : {"$match" : { "$and": [ { "Store_Name": {{Store_Name}} } ] }}
but visualisation needs atleast one input value and it will not work if i don't want to put any value in the filter. please assist.
Hi @nathanael, how can we lookup another collection in Metabase since we need to choose the base table from the dropdown only in case of Mongodb?
Also, I am facing issue in filtering of Metabase-MongoDB .
This is user interactive filter : {"$match" : { "$and": [ { "Store_Name": {{Store_Name}} } ] }}
but visualisation needs atleast one input value and it will not work if i don't want to put any value in the filter. please assist.
Hi @nathanael, @flamber , i meant that filter is not working, when i am adding value to the filter, it is not showing any result. pfa screenshot attached.