Allow field filters on a subset of data

Feedback and Requests
1

Hey everyone, this feature might be interesting.

the case:
I have a table that contains all employees data from HR and I'm creating a dashboard for specific department for example sales department.

Now all my charts in the dashboard already filtered to sales department but when adding field filters for employee names I cannot choose to only fetch the names for sales department, it shows all employee names for all departments.

My workaround for now is creating a separate table/view for the sales team only and working with it but it would be nice to make field filters more flexible.

2

You can do that via sandboxing Data sandboxes, or just make a question that filters employees and tell Metabase to use that question as the source of that filter

3

sandboxes is paid feature, and doing question in a filter will make me lose the linked filters option