6 Replies Latest reply: Dec 15, 2014 5:57 AM by anbu cheliyan RSS

    Average Set Analysis

    Phil Speight

      Each row of data includes appointment data, Patiend data, Reason Data.

       

      Can anyone tell me how I can work out the average appointments per patient only for reason1.

       

      i.e.

       

      Appt              Patient              Reason

      Appt1              Pat1                 Reason1

      Appt2              Pat2                 Reason2

      Appt3              Pat2                 Reason1

      Appt4              Pat1                 Reason2

      Appt5              Pat1                 Reason1

       

       

      I need Set Analysis to show Reason1 only ......

       

      Avg appointments per patient (by patient)

       

      Pat1 = 2 Appts

      Pat2 = 1 Appt

       

       

      The figure I need to show in the dashboard is for 'Reason 1' only and should be shown as below (not broken down by patient):

       

      Overall Avg = 1.5 Appts per patient

       

       

      Any help appreciated.

       

       

       

      Phil

       

       

      Phil