I want to build a burndown chart (separate chart for each item) for each of the 3 items in the slicer, i.e., Tree1, Tree2 and Tree3 for Unit 1 as shown below.
Filtered data for Tree1 for week 1 shows that a total of 44 items have been completed out of 90 leaving 46 incomplete items. This data gets refreshed every week.
Filtered Data (Example) – Week 1:
Below is the sample data for week 2. After week 2 there are 26 incomplete items.
As this data gets refreshed everyweek, I would like to add this data to the data used for building the burndown chart.
Data buildup for the burndown every week:
How can I build a burn down chart using the examples above?
Example burndown chart for Tree 1:
- All processed data resides in the table
- Add this data automatically to the table to build burndown chart
- Build the burndown chart and update every week
Thanks in advance!