Here are some general links on improving performance of workbooks.
There is also a built in feature for Tableau Desktop that allows you to investigate the speed at which particular actions are executed in Tableau Desktop, to initiate a performance recording follow the directions within this link: http://onlinehelp.tableau.com/current/pro/online/windows/en-us/help.html#perf_record_create_desktop.html?Highlight=perfo…
Hope this can help or at least get the wheels turning.
1 of 1 people found this helpful
IMHO, I think you are trying to do *too much* in Tableau. Given the volume of Record Level Calculations, it may be beneficial to write this logic into a physical table in your DB as a part of an ETL process. Trying to stuff too much logic into a Calculation in Tableau can certainly lead to performance issues (Of course that depends on the volume of the data).
On the other hand, you could use an Extract, and then Optimize the Extract, making these Row Level Calculations physical columns in the Extract. You will still get a performance hit during the Extract Refresh process, but it would resolve some performance when delivering the viz to an End-User.
Both methods should *help* resolve some performance issues (If this is the root cause). But it is best to view the Performance Recordings, and seeing if there is anything else that may be causing this run slowly.
If you aren't sure how to do this, refer here
Hope that helps.