Currently, this tool is not really a dashboard but over the next couple of months I hope to build one.
I created this project so that
- I can report cycle time for each work item on Visual Studio Online
- I can report the average cycle time grouped by effort
Eventually, I will have these reports display on a web page, in the meantime I created a console app that will export a csv file in the following format:
DateCommittedTime | DateClosed | Id | Title | Effort |
7/9/2014 10:05 | 7/9/2014 9:26 | 86 | Added Unit/Integration test project | 1 |
Then I take this output and copy and paste it into an excel file that will do the calculations.