topic Re: optimize expression in App Development

optimize expression

paulwalker — Thu, 11 Jan 2024 12:08:37 GMT

Hi Community,

I need to optimize the expressions, like same expressions I have all the months.

ROUND(SUM(agGr(
ONLY({<Type={'PRIMARY'},fill_flag={1},Month={$(=MAX(Month))}>}Sales)/100,
ID, Pno, description, Sales, rank))
+
SUM(agGr(
ONLY({<Month={$(=MAX(Month))},Name={'ABC'}, Flag={'ALL'}>}Sales)/100,
ID, Pno, description, Sales, rank)), 0.01)

chart taking to more time to display - is there any way to optimize expression?

Thanks in Advance!

Re: optimize expression

anat — Thu, 11 Jan 2024 12:26:00 GMT

can you try by creating the flag in load script like below :

if(Type='PRIMARY' and fill_flag=1,1,0) as flag1,

if(Name='ABC' and Flag='ALL',1,0) as flag2

then

use below set analysis logic:

ROUND(SUM(agGr(
ONLY({<flag1={1},Month={$(=MAX(Month))}>}Sales)/100,
ID, Pno, description, Sales, rank))
+
SUM(agGr(
ONLY({<Month={$(=MAX(Month))}, flag2={1}>}Sales)/100,
ID, Pno, description, Sales, rank)), 0.01)

Re: optimize expression

Anil_Babu_Samineni — Thu, 11 Jan 2024 12:55:40 GMT

@paulwalker In My opinion, you don't need two expressions and two times aggregate. Rather you can perhaps look this?

Round(Aggr(SUM({<Type={'PRIMARY'}, fill_flag={1}, Month={$(=MAX(Month))}, Name={'ABC'}, Flag={'ALL'}>} Sales)/100,ID, Pno, description, Sales, rank), 0.01)

Re: optimize expression

paulwalker — Thu, 11 Jan 2024 13:06:53 GMT

One expression is PRIMARY sales and another expression is NON-PRIMARY sales -

would it work above expression ?

Re: optimize expression

Anil_Babu_Samineni — Thu, 11 Jan 2024 13:24:03 GMT

@paulwalker In that case If you want to run both expression to the addition of non-sales. Because Aggr() usually kills the performance and on that you have used Only (). Not sure of the intent here. Maybe this still work 🙂

The correct expression,

ROUND(Aggr((SUM({<Type={'PRIMARY'},fill_flag={1},Month={$(=MAX(Month))}>}Sales)/100
+
SUM({<Month={$(=MAX(Month))},Name={'ABC'}, Flag={'ALL'}>}Sales)/100),
ID, Pno, description, Sales, rank),0.01)