8 Replies Latest reply: Aug 7, 2017 12:07 PM by Zachary Mostowsky RSS

    Populate data between Start and End dates in line line chart

      I have a programmed activity table where I have a Start and an End date for each activity, each activity have a Volume as other field.

       

      ActivityIDStart DateEnd DateVolume
      101/03/201210/03/2012120
      205/03/201220/03/2012245
      315/03/201209/04/201265
      425/03/201228/03/201272

       

      I wuld like to represent in a line chart the total value for each day between the min and max date (01/03/2012 to 09/04/2012). My problem is no the calendar, but to know for example the total value for a specific day. For example, the value for day 07/03/2012 will be 120/10 (10 is the total of days for activity 1) + 245/21 (21 total of days activity 2) wich will give me a total of 27.3125 for that day. As you see, in the original data, I have no data for that specific date.

      Example of what I would like to do.

      Graph.png

      Any help will be very apreciates. Thanks in advance.

      Patrick