1 Reply Latest reply on Oct 30, 2017 10:26 AM by patrick.byrne.0

    Improving Dashboard Performance

    Varun Sawant

      Hi Guys,

       

      I'm making a dashboard where I'm comparing a set of 25 metrics (each metric is a calculated field) over two periods. The difference(absolute value and percentage) between the two periods for all the metrics is shown on the side. These periods are controlled by a start date and end date parameters for each period. And the difference between the two periods for all the metrics is shown on the side. The dashboard also has 8 parameters,4 for each period, for the user to input values which are used in various metric's calculations. I would also want to mention that most of that 90% of the calculations have LOD expressions.

      The issue is, it takes around 4 minutes for the entire dashboard to render with around 3 crore rows, in extract mode. It would be extremely helpful if we can reduce that time down to a minute if not seconds. Unfortunately I cannot share the workbook but will try to provide all the information required to solve this.

       

      Thanks a lot in advance.