I want to create a financial burndown chart

1231 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have two tables. Purchases and Expenses, which tracks all my expenses (using date, amount, description, value, etc) and Account Tracker, which, based on Purchases and Expenses, calculates all my current balance (for checkings accounts) and remaining balance (for credit accounts).

I want to create a financial burndown chart, with the current/remaining balance for Y-axis and the expense date for the X-axis, but I have no idea how to do that. Can you help me?

3 Replies 3
Airtable Employee
Airtable Employee

Hey there! I'd recommend checking out this Community post which talks you through going about this with the help of scripting and our Vega-Lite extension. 😄

Hi, I tried to figure out the tool, but I couldn't figure out at all 😅

I need an answer "for dummies"

I hear you there; that method is definitely more involved, though I've also heard users having luck adapting the timeline view to better suit their needs. I'd recommend reviewing some of the other "burndown chart" threads asked in Community over the years, as users have posed a few different alternatives that might work for you!