Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Burndown Chart Logic

Topic Labels: Formulas
4446 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylor_Ferguson
4 - Data Explorer
4 - Data Explorer

Hello World!

I’m curious if anyone has a BurnDown chart solution. The logic I’m currently using is not effective.

1 Reply 1
Alivia_Smith
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey there,

I quickly put together an burn up chart, which is guess would be the same logic.

Basically my table that I build my chart off of is a single table with a Sprint (this is the number of the sprint) and a Completed Tasks column + a dropdown select with Forecast vs Actual vs MVP
And from there I have a value for each combination of sprint + type logged in, with the number of tasks done for the Actual type, forecasted for the Forecast, and a fix number corresponding to the scope for the MVP. Haven’t worked with counts and relations for these values, but I think it would be pretty easy to automate.

After that I add a graph block, with Sprint number as the X, and then Tasks as the Y, and Type as the group

For a burn down chart you would just replace the “done” tasks with “left to do” tasks…

Hope this helps!
Alivia