Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Try replacing your if() statements with set analysis. This typically has a major impact on performance.
Try replacing your if() statements with set analysis. This typically has a major impact on performance.
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