Create burndown chart in Excel using exported reports
Has anyone been able to build a report generated daily that shows number of points of active tasks? These excel spreadsheets would then need to be aggregated and a chart created from the data.
I'm trying to do this retro-actively but as Wrike cannot track the date a task is completed, even when I enter a range it only shows me all the active jobs per the project.
I would love any script you have that can aggregate these exported reports or any tips in setting up the reports correctly.Additional info: I run in sprints. I have crated a custom category for points and the table mode will total these even. By starting with a daily report, exporting it, and combing all the files, I can make my own burn down. It's just a same I have to do all this work and Wrike still hasn't figured out that this is something we need.
help.wrike.com/hc/en-us/articles/209604449-Reports-Overview#export
Hi Jesse, I think the first thing is to figure out how to capture the completed task dates in your Report.
Can you confirm that when building the Task Report you have set the following Filters?
- Status: 'Completed'
- Date Range: Last week (or define a custom range)
I also want to mention this Product Feedback post about Burndown charts, it would be great to get your vote here if you have not already 👍