• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dashboard calculation and speed

Y

ysherriff

Member
To all,

I created a dashboard and the calculations I have are slowing the dashboard significantly. I have made some modifications to increase speed but it is still taking too long for the calculation when I change a parameter or even change views.

I need help. What can I do from a maintenance standpoint to speed up the dashboard? I want to learn and I have learned a lot from this board and really appreciate your help.

Here is the link to the dashboard

https://www.dropbox.com/s/2p8yht5sq...ne Performance Report v1.5- formula.zip?dl=0
 
The workbook works fine on my PC, but I do have a high end PC with lots of memory.

The issue is the Sumproduct formulas at the top of the Chart Calx worksheet

They are accessing 20,000 columns 3 times x 54 Columns x the 20,000 rows x 54 columns.
 
Hi ,

What I see is that changing the selection in the left side , the level , does not load the system ; the display updates very fast for all selections.

Changing the selection in the right side , the payer type , again does not load the system , except for the first selection ALL PAYER TYPE.

You need to see what this calculation does , which is different from the calculations for all the other payer types.

Narayan
 
You must log in or register to reply here.
Back
Top