6 Replies Latest reply on Jun 28, 2018 5:50 AM by William Graf

    Graphing Orthodontic Patient Time in Treatment

    William Graf

      Hi there,

       

      I'm doing some analysis for an orthodontics practice. I'm trying to calculate the average time in treatment for patients exiting treatment in a specific month. The data is from a procedure log where each row is a procedure (e.g., starting treatment, check up exam, ending treatment, etc.). I've been able to get the data arranged in such a way that, for each patient, I can see how many days they were in treatment. I'm struggling to take this data and aggregate it in any meaningful way. Essentially, I'm trying to end up with a graph showing the average time in treatment for all the patients who completed treatment in a particular month.

       

      Hoping the attached packaged workbook will help.

       

       

      Thanks in advance,

      Bill