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?

       

       

      Regards

       

       

      Phil