Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Count({<AppointmentReason = {'Health'}>}patient_id) / Count({<AppointmentReason = {'Health'}>}TOTAL <appointment_month> patient_id)
Count({<AppointmentReason = {'Health'}>}patient_id) / Count({<AppointmentReason = {'Health'}>}TOTAL <appointment_month> patient_id)
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)
Worked a treat. Thanks