Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I need help on the function aggr
The expression "max (Aggr (count ([Type_Incident]), [Type_Incident]))" returns the maximum number of count([Type_Incident])
of the dimension [Type_Incident]
.
I would now find the [type_Incident], which corresponds to the max max (Aggr (count ([Type_Incident]), [Type_Incident]))?
Thank you for your help
P
hi,
try something like this
=only(if(aggr(rank(count (Type_incident)),Type_incident)=1,Type_incident))
hi,
try something like this
=only(if(aggr(rank(count (Type_incident)),Type_incident)=1,Type_incident))
Thanks, it's working
P