1 Reply Latest reply on Sep 12, 2018 9:17 AM by patrick.byrne.0

    Data modelling on daily aggregated data for KPI's datewise

    varun.malhotra.1

      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?

       

         

      UserDateManagerKPI 1KPI 2KPI 3
      A25-08-2018Xsum of values(for this person) e.g. collectionsum of values(for this person) e.g. Salessum of values(for this person) e.g. collection
      A26-08-2018Ysum of values(for this person) e.g. collectionsum of values(for this person) e.g. Salessum of values(for this person) e.g. collection
      B27-08-2018Zsum of values(for this person) e.g. collectionsum of values(for this person) e.g. Salessum 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