Hi Experts,
I have downloaded Tableau 2018.2 and am trying to create a dashboard with the same, i wanted to know if we can do remodelling in Tableau?
like suppose i have to show data for below KPI's then is it possible to create same in tableau?
User | Date | Manager | KPI 1 | KPI 2 | KPI 3 |
A | 25-08-2018 | X | sum of values(for this person) e.g. collection | sum of values(for this person) e.g. Sales | sum of values(for this person) e.g. collection |
A | 26-08-2018 | Y | sum of values(for this person) e.g. collection | sum of values(for this person) e.g. Sales | sum of values(for this person) e.g. collection |
B | 27-08-2018 | Z | sum of values(for this person) e.g. collection | sum of values(for this person) e.g. Sales | sum of values(for this person) e.g. collection |
Now all these KPI's value is based on sum of values for that person from different tables. I want to show these data in tableau dashboard but these calculations for sum and values of KPI's need not to be done at runtime so as to improve the performance.
Regards
Hello Varun,
Tableau Extracts can be materialized which will have the calculations populated as values in the data source instead of the calculations all being performed at run time.
+ Materialize Calculations in Your Extracts
Hope this helps!
Cheers, Byrne, Patrick