Skip to main content
Question

runnning total on a line chart

  • March 23, 2018
  • 0 replies
  • 74 views

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. 
This topic has been closed for replies.

  • Quickbase Alumni
  • March 25, 2018
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.

Forum|alt.badge.img+5
  • Quickbase Alumni
  • March 27, 2018
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.