I am trying to run a metabase[ v0.32.9] custom native query with mongo db[version - 3.14]. After running the query when we add the questions to dashboard,try to apply filter the metabase shows no valid fields on the selection.
Can anyone let me know how to apply filters on dashboard using mongodb custom native query?
Do I need to cast the result into particular type for filters? if yes then how to typecast the results?