I try to create dashboards without writing any line of SQL. So I wrote my questions on custom question and it works perfectly. (These question have 7 Inner Joins).
But the problem come when I place my questions in a Dashboard. I want to create several filters . When my filter is based on the first table I used in the question editor, I have a dropdown filter, that’s great, but when my filter is based on an other table (not the first), I only have a search box filter, where I can just type the label without any propositions…
How can I get a dropdown filter on one of these columns (from the joined tables)?
I know that SQL query can fix this problem, but I want to do it without any SQL line.