Performance issue - Aggr function

[RutiTaumanRubin]

Hi All,

I developed new app ,most of the KPIs in this app calculate with Aggr function and it worked fine (with ~1M records)

When I try to load more data (26 M records) the app drastically slows down and it's bring data only if we filtering the data.

Example for KPI calc:

Avg(if($(V_Date_LastMonth)=1 ,Aggr(
count(distinct if($(V_Date_LastMonth)=1 and Upper(Trim(ACTION))='OPENED',ID))
/
count(distinct if($(V_Date_LastMonth)=1 and Upper(Trim(ACTION))='DELIVERED',ID)),ISSUE))).

Could you please advise?

Thanks,

[Or · Accepted solution]

Try replacing your if() statements with set analysis. This typically has a major impact on performance.

[RutiTaumanRubin]

Thanks!

I change the calculation to set analysis  and add the following instead of Dim name: $(=GetObjectField(0,'CH24') and it's improve the performance