3 Replies Latest reply: Feb 21, 2014 4:51 PM by Tim Elder RSS

    Calculating Days in a chart

      Hi,

      I have data as follows

      DateTotal MinutesMin_BookedMin_Avial
      2/10/2014907515
      2/11/2014907515
      2/12/2014906030

      Assuming today is 2/10/2014.

      Today there is 15 minutes avialable

      Today thru 2/11 there are 30 minutes available.

      Today thru 2/12 there are 60 Minutes avialable.

       

      In a chart I would like to report how may days until a total of 45 minutes are avaialbe. In this scenario above, it would be 2 days from today.

       

      The chart would actually want to report the average number of days, by a variety of dimensions, until a total of 45 minutes is available.

       

      I hope this makes sense. Any help would be great. I assume aggr would need to be used multiple times.