Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have created the below expression in a bar chart measure and the set analysis ignoring the "HospitalName" doesn't seem to work. Even when I replace {$<[HospitalName]=>} with {1} my selections are still taken into account. In other charts, I have created simpler expressions using the above set analysis and it works as expected. Is there something i am missing here?
=Aggr(Count({$<[HospitalName]=>} if((HandHygieneRecordsMapped.Action = 0 OR HandHygieneRecordsMapped.Action = 1) ,[HandHygieneRecordsMapped.Id])), [HospitalName])/Aggr(Count({$<[HospitalName]=>} [HandHygieneRecordsMapped.Id]), [HospitalName])
Thanks .
Thanks for you answer BrunPierre.
The expression you provided was one of my former approaches which didn't work, as it recalculates every bar in the chart to 100%.