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

 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Create burndown chart in Excel using exported reports
[this list is visible for admins and agents only]

Superior

Próximas sesiones en vivo