Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

Performance issue - Aggr function

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,

 

 

 

1 Solution

Accepted Solutions
Or
MVP
MVP

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

View solution in original post

2 Replies
Or
MVP
MVP

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

RutiTaumanRubin
Creator
Creator
Author

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