Restrict initial number of rows on text table.

Question

I have text table with index and approximate more than 500k records. I have created calculation with index like index <= number of rows (number of rows is integer parameter initial value is 200 and user can change that up to 500K) Initial load time is more than 5 min.when you apply any filter that also taking more than 3min. How to increase performance of this dashboard ?

Amy Wu · Accepted Answer

Hi  @Govind Wavadane , Have you considered doing the calculations in Tableau Prep or Alteryx and loading them as an extract into the Tableau Dashboard? You could have several preset views based on user preferences, and different views for each. Tableau can take a long time to do calculations. Thanks, Amy

Steve Wood · Answer

Hi @Govind Wavadane​  Tableau's order of operations potentially explains some of this. INDEX() is a table calculation and evaluated quite late in the order of operations, so there is a good chance Tableau has had to do work on the whole data set before filtering down to your subset of records. The "paging" approach you're using here is probably more intended to avoid information overload for an end user than performance. Have you tried the performance recording in your workbook to see if there are any obvious problems? https://help.tableau.com/current/pro/desktop/en-us/perf_record_create_desktop.htm https://help.tableau.com/current/pro/desktop/en-us/performance_tips.htm Ta, Steve

Restrict initial number of rows on text table.

Tableau Desktop & Web Authoring

Related Learning

More Help