Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a chart expression:
[TFC Specialty Name Referred To] where count(distinct [Service ReferralID])=max(aggr(count(distinct [Service ReferralID]),[TFC Specialty Name Referred To]))
that gives me a number, say 999, but what i really what is the name of the TREATMENT FUNCTION, please engage and if you need more detail then call me on 07931 735736 (PERSONal mobile)
the team i am in are looking into this but are struggling, any help would be much app reciated !
May be this
FirstSortedValue([TREATMENT FUNCTION], -Aggr(Count(DISTINCT [Service ReferralID]), [TFC Specialty Name Referred To]))