runnning total on a line chart

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a line chart.  That shows # of defects and x axis is date submitted.  What I need to go along with this is a running total line that increases to show the grand total of defects.  Not sure if that is possible in QB.   here is what my chart looks like.

I need it to look like this.

I thought maybe a waterfall chart may work, but it's bars and can't do multiple lines.

So i've got numbers of defects grouped by week, but I need a grand total line as well. 
Photo of Johnny QuickBase

Johnny QuickBase

  • 300 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
If you want to report on weeks, you will want to create a weeks table, and then summarize the data to the weeks.  You'll have to pass the info around a bit, but if you filter the data you should be able to get it close.
Photo of Debbie Taylor

Debbie Taylor

  • 816 Points 500 badge 2x thumb
Here's a cumulative graph that CloudBase Services created for a client.
The months are the horizontal access.  Revenues are the vertical access.  
Each line shows a cumulative total.  And, there is a data table below.

Contact us via our website.  We can add some code to your Quick Base to create it.