6 Replies Latest reply on Oct 7, 2016 5:39 AM by Steve Demanovich

    Comparing Dates Dynamically and Running Totals

    Steve Demanovich


      I am trying to measure improvement in completing appointments by measuring how many appointments have a certain status each day.  I have a data sample attached, but where I am struggling is comparing the status at any given time to a date.  For example, there are x number of total appointments. On 9/7 there are y that are not completed or cancelled, on 9/8 there are now z that are not completed or cancelled, on 9/9 there are zz that are not completed or cancelled.


      I may not be explaining this well but somehow I need to measure time stamps every day to see how many overdue appointments exist.  The real data started in January and will continue indefinitely...attached is just a small sample.


      Any ideas?