3 Replies Latest reply: Dec 24, 2014 4:00 AM by Phil Speight RSS

    Percentage By Dimension & Set Analysis

    Phil Speight

      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?