We have a table in the database that we can use for a field filter.
Example: the table is filled with campaign names.
We have dashboards per client that show their data based on a locked ID filter.
Is there a way to make sure the field filter only shows results based on that prior locked filter?
I tried a couple of things but all campaign names are visible in the filter.
We use Metabase 0.34.1 and Druid as the database source so can’t make a filter in the SQL since Druid doesn’t support that. We can only use dashboard filters.
Who knows a solution for this?