Good Monday fellows! Anyone have an idea on my case? Thanks.
1 of 1 people found this helpful
You can deal with this in a couple of ways;
1. In your filters, select the drop down caret > Customize > Show Apply Button. This will allow you to set a few filters at once without waiting for data changes to occur
2. Setup a 2nd dashboard and put your filters and parameters on that so that users have to go through that dashboard and make all of their selections before they can view the data. The underlying changes are then made offscreen which gives off optics that the query is running faster.
Thanks Peter .
For solution (1), because I have around 10 filters, using this approach should reduce each value loading time in a filter.
However, loading still occurs between the next filter 2nd, or the 3rd or onward filters.
For solution (2), can you share some more tricks on how to let users go via the selection before the data is loaded?
In the dashboard, the existing parameter control is able to cater this logic (i.e. user can go via all selections before data load), but user thinks such parameter control (i.e. drop down) display was not interactive enough.
Thanks again for your time!
Sorry, I've got no ideas along those lines. I don't like the current hack way that Tableau does navigation between sheets so don't tend to use it. I am sure have an idea somewhere in the mix for a kind of 'magic button' that would allow several programmable actions to occur (including navigation), but couldn't find my own idea when I looked for it just then.
You have already brought me some insights on this. Thanks Peter!