Quick Base Discussions

Expand all | Collapse all

runnning total on a line chart

  • 1.  runnning total on a line chart

    Posted 03-22-2018 21:20
    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. ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1717996/RackMultipart20180322-53520-15tbq4z-chart_inline.jpeg?1521753451">

    I need it to look like this.
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1717997/RackMultipart20180322-62187-2egtg3-tst_inline.png?1521753548">

    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. 


  • 2.  RE: runnning total on a line chart

    Top
    Contributor
    Posted 03-25-2018 06:50
    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.


  • 3.  RE: runnning total on a line chart

    Posted 03-27-2018 00:48
    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.