Hello!
I have a special request from the client
I have a dashboard that contains a main filter that filtering the field "Office name". All views in the dashboard affected by this filter.
For one view I have to choose from a secondary filter that the "Choice List Values" is what the main filter selected.
For example: In the main filter I choose office1-4 (from 10 offices)
In the secondary Filter, I want to get a list of values that contains Office1-4 and from that list I will choose only the Office1-2.
I tried to make it through the use of presentation variable in the main filter. I've set up the secondary filter that contains the SQL statement with the presentation variable values in the WHERE clause. It worked fine. The List of values in the secondary filter match what the main filter selected
The problem is that once I chose values in the secondary filter, the chose values also affected the choice of the main filter and all other dashboard views.
Does anyone have an idea how to overcome it
Thank!