Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 expression in my report....
Individual Cluster and Lifestage = count({$} distinct VisitParty)
Benchmark (avg) for the same Lifestage across different Cluster = aggr(nodistinct avg(aggr(count (distinct VisitParty), Branch_Cluster, Visit_Lifestage)), Visit_Lifestage)
The above 2 expression gave me correct answer of what i want... But, when i clicked on a selected Branch, my benchmark will have the same value as the Individual Cluster and Lifestage, where and how should i insert TOTAL/{1} or anything to make the Benchmark number stay the same with regardless of what filter i choose?
TQ
Hi
Try like below
= aggr(nodistinct avg({1}aggr(count ({1}distinct VisitParty), Branch_Cluster, Visit_Lifestage)), Visit_Lifestage)
Hi
Try like below
= aggr(nodistinct avg({1}aggr(count ({1}distinct VisitParty), Branch_Cluster, Visit_Lifestage)), Visit_Lifestage)