2 Replies Latest reply on Oct 11, 2016 8:27 AM by rcbmi1

    Creating a Calculation which includes previous data

    rcbmi1

      Hi all,

       

      I have a data set comprised of numbers of hours. I would like to create a graph which shows the number of hours worked to a given date; weekly evaluation would be the ideal.

       

      For example:

       

      01/01/2016     16

      01/08/2016     24

      01/21/2016     20

       

      Total hours (projected): 75

       

      For the graph, I would like 01/01/2016 to show 16, 01/08/2016 to show 40, and 01/21/2016 to show 60. How do I accomplish this, short of creating calculations for every repetition of every field I want to evaluate? The purpose is simply to graph how many hours we've put in to a job at a given date.

       

      Thanks in advance for any and all ideas,

       

      James