Percentage By Dimension & Set Analysis

[Anonymous]

I am trying to show a percentage by dimension.  for all patient appointments.  This works using the following :

(

Count(patient_id)) / (Count(TOTAL <appointment_month> patient_id))

The issue I have is that I only want to include any records which have a AppointmentReason = 'Health'

How do I update the expression to include the set analysis also?

Regards

Phil

[Gysbert_Wassenaar · Accepted solution]

Count({<AppointmentReason = {'Health'}>}patient_id) / Count({<AppointmentReason = {'Health'}>}TOTAL <appointment_month> patient_id)

[Anonymous]

Hi try like this

If Condition

=Count(distinct If(AppointmentReason = 'Health',Patient_Id)) / Count(Total If(MonthName = appointment_month,Patient_Id))

Set Analysis:

Count({<AppointmentReason = {'Health'}>}patient_id) / Count({<AppointmentReason = {'Health'}>}TOTAL <appointment_month> patient_id)

[Anonymous]

Worked a treat.  Thanks