Limit Chart

[jood_ahmad]

Hi Experts,

I need a help.

I have a huge dashboard and a huge data with aggregations and nested aggregation and i need to get a better performance for my end users; once they open the dashboard it open with all data i need to limit the shown data and calculation time for these charts to get only the max month.

i try to add calculation condition based on the Year and month but it doesn't work, and keep in your mind that no date used in all charts in that sheet.

So, how can i limit the data once the dashboard it opened to be only for the max month and the user can change the selection to any other dates he wants.

Thank you very much,

[eliran]

Hi Ahmad,

Three options:

1. Use set analysis on expressions to take data of the max year-month

2. Set calculation condition on each chart, =getselectedcount(Year)=1 and Getselectedcount(Month)=1

3. set a trigger when opening the sheet / document to select only one period

I would advise on the first, if something isn't working for you for that method (applying set analysis) post the problem.

BR,

Eliran.