Might be a newbie question but I have gone through the documentation and searched help. If there is more advanced documentation or blog somewhere I welcome it.
- I am unable to add two filters to a dashboard with a question that has two joined tables. One table has a date filter and the other table has a drop down text filter. It seems to matter which table I add first as to which filter works but I need both of them to work at the same time.
That leads me to…
- What is best practice for setting up questions if you are developing dashboards for consumers so that you can access features like multiple filters. (Not in the role of an exploratory user.) Should you use custom SQL with variables or custom questions? I have used several other analytics tools to develop for clients so I am used to writing code. I just want to avoid going down the wrong rabbit hole.