2 Replies Latest reply on Jul 2, 2016 9:03 AM by Stephanie Beadman

    Datediff and create bars based on start date month

    Stephanie Beadman

      Hi all,

       

      I'd like to create a bar chart that tells me the average number of days it took for a patient to go from "case open" to "on therapy."

       

      I know that I can use the datediff function for this, but I would also like to view the data by quarter - i.e., the average number of days it took for a patient to go from case open to on therapy if their case open date was in Q1, the average number of days it took for a patient to go from case open to on therapy if their case open date was in Q2.....etc.

       

      I can't seem to find an elegant way to do this.

       

      Workbook attached.

       

      Thanks a lot!

       

      Stephanie