I have now spent way too much time trying to figure out how to tailor a burndown chart for the type of data that I have. I have the following data for risks, where the create Date is when the risk is identified, ID is the Risk ID and Complete date is when the risk is remediated. For the risks that have been created before 1/1/2020, they will be tracked in the burn down for 2020. All the risks identified in 2020 risks will be tracked in 2021, etc.
Created DateIDCompleted Date Sprint
| |
| 5/18/2018 | 1 | 4/30/2020 | 2020 |
| 6/19/2019 | 2 | 5/30/2020 | 2020 |
| 1/5/2020 | 3 | 5/30/2020 | 2021 |
| 2/4/2020 | 4 | 6/15/2020 | 2021 |
| 3/15/2020 | 5 | | 2021 |
| 4/30/2020 | 6 | 5/30/2020 | 2021 |
| 5/30/2020 | 7 | 10/15/2020 | 2021 |
| 6/30/2020 | 8 | | 2021 |
| 1/2/2021 | 9 | 2/1/2021 | 2022 |
| 2/4/2021 | 10 | | 2022 |
Not every risk has been remediated within the 12 months burn down period. If there is no completion date, the risk outstanding Here is what I need help with:
- Create a measure for the risks remaining for each year.
- Create a burndown line for each year of planned risks to be remediated (total outstanding risks at the beginning for each sprint/12 months)
In addition, I would like to be able to add the risks that did not get remediated in the prior year to the following year.
I have created a date table that starts on 1/1/2020-12/31/2022. I have watched the https://www.youtube.com/watch?v=uq5PQg_hZro video, but have not been able to be successful in implementing.
Thank you in advance for your help!
