Sorry if this is a dumb question, but I'm pretty new to metabase and can't find anything in the documentation about this scenario.
I'm trying to setup a dashboard, and the primary filter is "Employee". The employee table as ID and Name columns.
Beneath that I have a number of questions from various data sources, each which have an "employee_id" column.
I'd like to add a filter to the dashboard where you pick an employee by NAME, but then filter the questions on the dashboard by ID.
Is it possible to do?