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

    Creating a Calculation which includes previous data


      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,