Aggr Expressions NOT Working when using Custom Dimension Pick

EmmaMark — Sun, 26 Apr 2020 14:08:14 GMT

Any idea how to get this set analysis right

the first line works the others are zero

PICK( Match(ORDEM1,
$(=Concat({<ORDEM1 -= {''}>}DISTINCT chr(39) & ORDEM1 & chr(39),',',ORDEM1))
),
sum({<Ano={$(=Max(Ano))},[Mes]={'Fev'}>}Aggr($(vExpressao1), Ano,Mes)),sum({<Ano={$(=Max(Ano))},[Mes]={'Fev'}>}Aggr($(vExpressao2), Ano,Mes)),
sum({<Ano={$(=Max(Ano))},[Mes]={'Fev'}>}Aggr($(vExpressao3), Ano,Mes)),sum({<Ano={$(=Max(Ano))},[Mes]={'Fev'}>}Aggr($(vExpressao4), Ano,Mes))

)

Re: Aggr Expressions NOT Working when using Custom Dimension Pick

JGMDataAnalysis — Sun, 26 Apr 2020 16:44:05 GMT

De acuerdo a lo que interpreto, tu objetivo es armar una tabla sencilla que incluya como dimensión el campo [ORDEM1] (proveniente de una isla) y la métrica que no está funcionando correctamente.

De ser así, te sugiero que añadas el calificador TOTAL para evitar que tu métrica sea agrupada por los valores dimensionales de [ORDEM1]...

Re: Aggr Expressions NOT Working when using Custom Dimension Pick

EmmaMark — Sun, 26 Apr 2020 23:02:38 GMT

Gracias JGM
Ahora solo estoy teniendo un problema con la Expresión 23,
No está haciendo que el porcentaje con decimales sea igual al Total.

******,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao23), [Ano],[Mes]))******

PICK( Match([ORDEM1],$(=Concat({<[ORDEM1] -= {''}>}DISTINCT chr(39) & [ORDEM1] & chr(39),',',[ORDEM1])))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao1), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao2), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao3), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao4), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao5), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao6), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao7), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao8), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao9), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao10), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao11), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao12), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao13), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao14), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao15), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao16), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao17), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao18), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao19), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao20), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao21), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao22), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao23), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao24), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao25), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao26), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao27), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao28), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao29), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao30), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao31), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao32), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao33), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao34), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao35), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao36), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao37), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao38), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao39), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao40), [Ano],[Mes]))
,Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao41), [Ano],[Mes]))

)

Re: Aggr Expressions NOT Working when using Custom Dimension Pick

EmmaMark — Mon, 27 Apr 2020 20:48:55 GMT

Sum({<[Ano]={$(=Max([Ano]))},[Mes]={'Jan'}>} TOTAL Aggr($(vExpressao23)*100, [Ano],[Mes]))*

thank you

topic Re: Aggr Expressions NOT Working when using Custom Dimension Pick in Español

Aggr Expressions NOT Working when using Custom Dimension Pick

Re: Aggr Expressions NOT Working when using Custom Dimension Pick

Re: Aggr Expressions NOT Working when using Custom Dimension Pick

Re: Aggr Expressions NOT Working when using Custom Dimension Pick