set analysis dimension month

[rafael_neves]

Hello.

I have a function that ignores the dimension of month when I put it in a graphic.

how do I for this part of the function consider the dimension that is displayed?

I will use as an example the month of October

without filter the graphic marks a number of 301

with filter in October o Graph mark 529 (Correct Number)

I think I'm missing out on this part.

Count({<CUS_CUST_ID={'=SUM(LL_Maximo_Mes)=0'},PACKAGE_CONTENT={'publications'} >} distinct CUS_CUST_ID)

Thanks a lot for the help

[juraj_misina]

Hi,

When you select a month, only that month is considered for your set analysis. So in October there are 529 customers with Sum(LL_Maximo_Mes)=0. But some of those customers can have Sum(LL_Maximo_Mes)<>0 in other months, therefor they are excluded by your set analysis. I don't think you can solve this with set analysis, I think you'll need Aggr for this. Something like

Count({<PACKAGE_CONTENT={'publications'} >} If(Aggr(Sum(LL_Maximo_Mes), Month, CUS_CUST_ID)=0, distinct CUS_CUST_ID)

Hope this helps.

Juraj

[rafael_neves · Accepted solution]

Thanks for  help.

I found the answer by placing an if inside Aggr

sum(
Aggr(
if(
Count({<Content={'publications'}>} distinct Cust)=1
and sum(LL)=0
,1,0),
Cust, Ano_Mes
)
)