I have requirement for Dashboards like.
1. I have different filters in Dashboard Filter1, Filter2, Filter3.
2. If I Select All Values in Filter1 it should take Query 1 from Database and show the values accordingly or If I select any particular value or multiple values in Filter1 it should fetch the data using the Query 2 from database.
How to write a custom query in tableau so based on the filter selection the query should switch (Query 1 or Query 2).
Thanks in advance for help.