2 Replies Latest reply: Aug 9, 2013 10:48 AM by KAITLYN WEBB RSS

    Nulls in Bar Chart

      I have a bar chart that depicts patient puntualtiy.  I want to be able to show the % of patients that are early, on time, and late.  The logic is quite simple,

       

      Appointment DateTime - Arrived DateTime

       

      (See attachment for sample chart)

       

       

      My issue is that there are null values in the Arrived DateTime column which is giving me a forth value in the chart.

       

      Can anyone think of a way to disregard the nulls and only look at the Arrived DateTime when it is populated? (Nulls mean the Patient Cancled or No Showed)