I am new to Metabase and trying to query MongoDB. Now that I am able to write a complex native query to get what I needed, I wanted to filter in dashboard. However, looks like I have to use variables in the Query itself.
Is it possible to filter the query results rather modifying the query using variable?
Thanks @flamber. I didn’t know numbers where not supported. I changed the types and now I can see that the drop down shows Category. Now facing with a different issue.
[
{
"$match": {
"my_var": {{a}}
}
},
]
This is returning no results even if I type “iteration_1” in the filter textbox. However If I change the query like below it works.