Hello, I'm beginner in using metabase, my problems is that I have two different tables that each have a day of the week field (0,1,2,...,6). Using the data mapping, from Configuration/Data Model, I map each one (Sunday, Monday, Tuesday,..., Saturday).
Then I create a dashboard with questions for each table. When adding a "day of the week" filter to the dashboard, the mapping is maintained if I only choose one table.
When I choose that the same filter changes the field of both tables, I lose the mapping, and it only makes me a dropdown with the original values(0,1,2,...,6).
This occurs to me using GUI and using SQL with variables "{{day_of_week}}".
Any idea how can I fix this? Thanks in advance!
on the first post