Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys - I have a problem. I can't show % of each modality (type of diagnostic exam) per year as % in stacked chart. Tried using 'relative' but just shows everything as % of entire 4 years worth of total! What I have so far is...
=count({<[AD Modality]-={X,Z,P},[AD Activity or Demand]={'Activity'}>}[AD CRIS No.])/
count({<[AD Modality]-={X,Z,P},[AD Activity or Demand]={'Activity'}>}TOTAL<Period>[AD CRIS No.])
I'm basically using set analysis to exclude X,Z and P (hospital terms) and to only show Activity. This set analysis works well as I've used it elsewhere. I'm counting by number of CRIS No. (AD CRIS No.) codes.
Where I'm failing is trying to show each Period as a stacked chart, to show how each modality is made up in % terms. I'm not getting anywhere...really appreciate your help guys! Rgds