My problem is quite simple, and I believe I can do what I am looking for with Metabase, but so far no luck in getting it working so I’m calling for help.
I have a simple DB to collect the time spent by employees on a given projet. It has only two tables:
cdt.project_code is a foreign key to project_desc.code
I believe my data model is configured as it should:
I have a dashboard that I was able to setup, that allows users to filter by project:
The dashboard works perfectly but users don’t find it easy to look in to the dropdown for their project, when it displays only the dozens of project codes that we have in the DB.
So is it possible to have the filter dropdown display project names instead? I.e. project_desc.description
Thanks very much for your help!