Replacement to Aggregate Function

[Shiva123]

Hello,

            Everyone this is the same point  i have been circling about.I have an aggr function in my expressions and they are making the  dashboard to perform slow and sometimes the dashboard crashes. Is there any way to replace aggr function so that the dashboard would perform better . i tried total function and it didn't work . The result which is obtained by using aggr function is absolutely correct .

ex  of my expression

SUM(AGGR(

Num(((SUM({$<Period={">=$(=MAX(quarter_num)-8)"},Category={"Revenue","Adjusted Revenue"}>}Net_amount)*(-1))/%_Divider),'#,##0.0')

                                                               *

                                            SUM({<Sub_cateorgy = {$(=If(GetFIeldSelections(Sub_cateorgy )>0,Chr(34)&Concat(Sub_cateorgy ,chr(34)&','&chr(34))&chr(34),'*'))}>} Ratio)

                                                                                             ,dim 1 , dim2 , dim 3, dim 4)

                                                                                    )

[sunny_talwar]

May be move part of the calculation (whatever you can) to the script. Alternatively, you can perform the whole thing in the script, but then you loose the flexibility of getting the information based on change of selections.

[Shiva123]

yes exactly  i thought the same to move the upper part , but they are like different categories.

[sunny_talwar]

Different categories? What do you mean?

[Shiva123]

i mean .. the values for the categories are many ex : 1 exp  :  category ={'rev,adj rev'} 2. exp same expression bu t category={'sales,expenses'} like this...

[sunny_talwar]

okay then what is the issue? I am not sure what you are looking for if you know what to try?

[Shiva123]

HI,

       sunny  expression works fine but the thing is that i want to replace aggr function in the expression , because its kind of crashing the dashboard , is there any way to replace aggr with any other function .

Thanks

[sunny_talwar]

Can you share an app where you have the Aggr() function used?

[Shiva123]

sure

[Shiva123]

stalwar1‌  here is the app ..