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

    Calculating Days in a chart


      I have data as follows

      DateTotal MinutesMin_BookedMin_Avial

      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.