Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
)
)
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
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
)
)