Hi all!
I’m stuck trying to create a cumulative time-series chart for a simple cash flow.
My users can add financial data (Revenues and Costs) within a single data type “Financial data”. This creates a line in the database with the amount, the date and a cathgorisation of if it’s a revenue or a cost.
I would like to have a daily time series chart that in a cumulative way adds up the values (adds the revenues and subtracts the costs). For example: day 1 is 0 ; day 2=+200-100=100; day 3 100+50-100=50; day 4=50+300-150=200 and so on. I have installed the chart.js plugin but willing to use other solutions if you think that are better.
Can someone please help me create this chart and guide me through the whole process?
Thanks so much in advance for the help the community can give me!!
Cheers
Here an example of the final result (the light grey line is the previous period):
