There could be a number of reasons loading is slow.
If you have access to Desktop, you might try changing your filters to include the APPLY button; your worksheet will only recalculate once the user has selected all the choices for a particular filter (rather than recalculating each time a minor change is made).
It probably a good idea to switch your filters to Relative Values Only, as well, as this will eliminate dead-end choices.
If you have a LOT of filters that need to be set, you might opt for a "CHILD LOCK" parameter. I use this on my dashboards that require a lot of computational power.
Make the Parameter the first item in your filters...
When the lock is OFF, display NOTHING. The user can set all the filters without waiting for the computer to calculate what to display...
'When the lock is turned ON, only then are the filtered values displayed.
I hope this offers some hints. --Michael
Thank you for the useful tips Michael.
However I don't think the filters are the cause of the slow loading problem. As I mentioned, it's very slow when open the report and switch tabs as well. This issue happened like 3 times during the past month, normally the report performs well.
Make sure the packaged workbook is saved on your local (e.g. laptop) hard drive. I recommend to my end users that their Tableau Repository is on their local hard drive, not a network drive, as that helps with performance.
Tableau software should be saved on a local drive as well for best performance.
Is there enough RAM on the affected computers? I notice that a LOT of people don't close down applications when they're done with them so I recommend closing everything that isn't needed and trying again, especially web browsers, even closing tabs that aren't necessary if the browser itself can't be closed.
The fact that performance is intermittent is tricky. Note the date & TIME that the slowness events happen and then talk with IT to see if they are doing something around that time. It could be anti-virus scanning -- for some illogical reason we have a virus scan that happens early afternoon, consumes a bunch of computer resources (RAM and CPU), and thus slows down overall computer performance