Adding cumulative field - Degrading dashboard performance

[bharani8]

Hi Experts - Any idea what is the work around for this? While adding the cumulative calculation field in an straight table, my dashboard performance is degrading (takes 5 to 10 Mins to refresh). Plz Help.. Let me know if any other info is required?

Thanks!

Bharani

[Anil_Babu_Samineni]

Can you cross check the RAM for that application in your Task Manager? And indicate us whether how many records are there? And explain the formula you used ??

[bharani8]

Hi i see as below in mu Task manager... I would have loaded around 15 Lakhs rows.. and the formula for calculating cumulative i used was

rangesum(above(total sum({<AGED_DAYS_SUMMARY_ID -= {'[6] NO RECEIPT'}>}USD_INV_DOLLARS)/1000000, 0, rowno(Total)))

and also tried below formula as well

above(sum({<AGED_DAYS_SUMMARY_ID -= {'[6] NO RECEIPT'}>}USD_INV_DOLLARS)/1000000)+sum({<AGED_DAYS_SUMMARY_ID -= {'[6] NO RECEIPT'}>}USD_INV_DOLLARS)/1000000

[Anil_Babu_Samineni]

Only 15 L, Then it won't problem. Could be problem with RAM size only. What was RAM ??

[bharani8]

8GB RAM..

[Anil_Babu_Samineni]

I even wonder - Why 5-10 Minutes occupied to fetch data? Does this getting stuck or some thing new? Because my specification are very lower than your and i am maintaining some around 2 M - 4 M Rows in my report. May be marcus_sommer has some insights

For a While, Could you try this for me. I don't recommend to use -= but this may useful for you

rangesum(above(total sum({<AGED_DAYS_SUMMARY_ID = E({<AGED_DAYS_SUMMARY_ID = {'[6] NO RECEIPT'}>}AGED_DAYS_SUMMARY_ID)>}USD_INV_DOLLARS)/1000000, 0, rowno(Total)))

[bharani8]

Ok Sure .. i will give a try on this and keep you updated..

It is not getting stuck.. it is taking time to refresh.. with that Green Sleeping line...

[qliksus]

So does using a simple expression like this too take the same time?

rangesum(above(total sum(USD_INV_DOLLARS)/1000000, 0, rowno(Total)))

Also as you are using a straight table why not use the in-built feature for accumulation using the below expression

sum({<AGED_DAYS_SUMMARY_ID = E({<AGED_DAYS_SUMMARY_ID = {'[6] NO RECEIPT'}>}AGED_DAYS_SUMMARY_ID)>}USD_INV_DOLLARS)/1000000

[bharani8]

Even this is taking same amount of time to refresh

[bharani8]

Full Accumulation is not working when we have more than 1 Dimension.. Not sure Why..