Reporting Cumulative Values

Does anyone know of a way of creating a graph that shows the cumulative sum of values in a table?

Y axis would be integer number
X axis would be days (something like the last 30 days)

My table contains records that contain the number of open print jobs for our production team. I would like to see a graph showing the total number of open print jobs on each of the last 30 days. This way we can see if we are closing print jobs faster than opening them (IE we are getting all of our work done) or the number of open print jobs keeps going up (we need to add more staffing to get the print jobs closed out).

I have tried a handful of ways to do this, but can’t find anything that allows me to display a sum of values vs a date.

Thanks!

Hi Eric,

Depending on your schema, you might use one of the following approaches.

If each Print Job is a record, then your Chart Settings could be:

Alternatively, if “Open Print Jobs” is a number field in a record, then your Chart Settings could be:

2 Likes