I am trying to create a card that shows a burndown representation of my data. My data has to do with Courses, estimated time to Complete (Duration), and Actual Hours to complete. I think to create a burndown I need a new column that gives total Duration per year of all courses due that year and then I want to be able to subtract hours to complete for each month and show burndown over the year. Anyone have any thoughts on best way to do this?
Course | Year Due | Month Due | Duration | Hours to Complete |
---|
A | 2023 | December | 1 | 0.5 |
B | 2024 | February | 1 | 1 |
C | 2024 | March | 1 | 1.5 |
D | 2025 | January | 2 | 1 |
| | | | |