I have a dashboard made of several visuals based on SQL query. I created multiple variables to be able to add filters in my dashboard. All my variables are setup as field filters. All linked to some fields available in my query.
My problem is that Metabase show all possible field value in my filters dropdown list.
For example, if i have a restriction in my SQL query to limit data to only customers based in Belgium and France, I will still have all the country in my filter dropdown list. And for example the ability to select Germany, selection that will show no result as datas are already filtered to show only Belgium and France.
How can I limit my filter dropdown list content to existing values ?
Thanks for your support.