How to create a line graph with a cumulative value?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

I have a table with a TransactionDate column and a Profit/Loss column. I would like a line graph with Date on the X-axis and Cumulative Profit/Loss on the Y-axis. I cannot find the right settings or formulas to put this together. Is this easy to do?

Photo of Roger

Roger

  • 0 Points

Posted 5 years ago

  • 0
  • 1
Photo of QB_Support_Brian

QB_Support_Brian

  • 40 Points
Hi Roger,

I think the trick with this one is getting QuickBase to calculate the cumulative values. The setup is a bit complex so if you can go to Help > Manage Support Cases > + New Support Case, a Customer Care specialist will be happy to take a look at your app with you to get it set up.



Thanks!

Brian
Photo of Matt NZ

Matt NZ

  • 296 Points 250 badge 2x thumb
There is now a new chart type called "Waterfall".
This should do the trick :)