Average of a Distinct Value of 2 dimension

[meilim26]

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

[MayilVahanan · Accepted solution]

Hi

Try like below

 = aggr(nodistinct avg({1}aggr(count ({1}distinct VisitParty), Branch_Cluster, Visit_Lifestage)), Visit_Lifestage)