Filter on Custom Question Dashboard


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.


Hi @Pedroniel
It sounds like you’re seeing the following issue: - upvote by clicking :+1: on the first post