Allow field filters on a subset of data

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.

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

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