Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a chart with a cyclegroup dimension and an expression to calculate Min(all Aggr(Count(Code),Region ))
I want that this calculation changes by changing the dimension group and if I change dimension to date it calculate s
Min(all Aggr(Count(Code),Date)).
how can I do?
HI @marjan_it
Try like below
Min(Aggr(Count(Code),$(=GetCurrentField([New Group]))))
HI @marjan_it
Try like below
Min(Aggr(Count(Code),$(=GetCurrentField([New Group]))))
Thanks so much, but I have another question, If we want to add a condition in expression to say that
count(if(GetCurrentField([New Group]))=Date ,Code)) How to do it?
Hi @marjan_it
Try like below
count(if(GetCurrentField([New Group])='Date' ,Code))
pls use @name to get notification or create new thread