Is there a way to build a chart or graph that shows a running total from a start to finish date fields?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I'm trying to build a graph that sums a numeric field across all records in a table on the y axis. On the x axis I would like to have a date, grouped by week or month. Each record has a start and end date field. I would like the numeric field summed only if the date on the x axis falls within the start and end date fields for that record.

I have been able to build a bar chart that shows the total on the y axis, but I have only been able to set a single field on the x axis, the start or end date. Is there a way to show the running total from start to finish?

If there isn't a way to build this using a chart, is there a solution using a report or timeline?
Photo of Evan


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Keith


  • 20 Points

Just brainstorming here because I'm not sure I know the full answer.

Do you have it built where the Y Value is that number field, and then what date field would you want on your X axis? You can select that field and have it grouped by week or month.

Then you could have a filter to filter out all records where that Date isn't within the start and end date.

This seems possible, but if you can give us more information, or a screen shot, we should be able to help you get what you need.