Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following Aggr expressions that calculate an indicator relevant to my business
Aggr(Sum(Aggr(max(Aggr(if(
XCOUNT=0 AND Y>3000000 AND TYPE='A' AND ZCOUNT=1,
1,0),ID,MONTHNUMBER,NAME)),ID_3,MONTHNUMBER)),NAME)
+
(3*
Aggr(Sum(Aggr(max(Aggr(if(
XCOUNT=1 AND Y>3000000 AND TYPE='A' AND ZCOUNT=1,
1,0),ID,MONTHNUMBER,NAME)),ID_3,MONTHNUMBER)),NAME)
)
+
(4*
Aggr(Sum(Aggr(max(Aggr(if(
XCOUNT=2 AND Y>3000000 AND TYPE='A' AND ZCOUNT=1,
1,0),ID,MONTHNUMBER,NAME)),ID_3,MONTHNUMBER)),NAME)
)
+
(5*
Aggr(Sum(Aggr(max(Aggr(if(
XCOUNT=3 AND Y>3000000 AND TYPE='A' AND ZCOUNT=1,
1,0),ID_2,MONTHNUMBER,NAME)),ID_3,MONTHNUMBER)),NAME)
)
+
(2*(sum(if(Aggr(max({< TYPE={'A'} >} Y),ID_3,MONTHNUMBER)>25000000,1,0))))
+
SUM(Aggr(if(
TYPE='P' AND (Date#(VCT_MAX, 'YYYYMMDD')-Date#(CON, 'YYYYMMDD'))>30 AND Y>=3000000 AND AGGR(COUNT(ID_2),ID_3)>=1,
-1,0),ID,MONTHNUMBER,R))
I am trying to plot it by MONTHNUMBER or by R and having no luck.
Could you guys please point me in the right direction?
Thank you!
HH
I think your dimension (MONTHNUMBER ) needs to be an element of the aggr at the highest level. I've also found it needs to be applied at each component. For example if I have an expression being
sum(aggr(numerator_expression,field))
/
sum(aggr(denominator_expression,field))
To get that to plot across a dimension field DIM, you would have
sum(aggr(numerator_expression,field,DIM))
/
sum(aggr(denominator_expression,field,DIM))
Having DIM as part of an aggr inside inside expressions (eg numerator_expression) is not enough, and the format below won't work
sum(aggr(
sum(aggr(numerator_expression,field))
/
sum(aggr(denominator_expression,field))
,DIM))
I think your dimension (MONTHNUMBER ) needs to be an element of the aggr at the highest level. I've also found it needs to be applied at each component. For example if I have an expression being
sum(aggr(numerator_expression,field))
/
sum(aggr(denominator_expression,field))
To get that to plot across a dimension field DIM, you would have
sum(aggr(numerator_expression,field,DIM))
/
sum(aggr(denominator_expression,field,DIM))
Having DIM as part of an aggr inside inside expressions (eg numerator_expression) is not enough, and the format below won't work
sum(aggr(
sum(aggr(numerator_expression,field))
/
sum(aggr(denominator_expression,field))
,DIM))