Forum Discussion

RogerRoger's avatar
RogerRoger
Qrew Member
11 years ago

How to create a line graph with a cumulative value?

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?

Formulas and functions
reports and charts
Tables and fields
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    11 years ago
    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
  • MattStephens's avatar
    MattStephens
    Qrew Cadet
    7 years ago
    There is now a new chart type called "Waterfall".
    This should do the trick :)