Release Burnup Chart in TFS 2015

With TFS 2015 you can create and add charts to your team dashboard quite easily. In a previous post I was explaining how to create a simple task burndown chart. So in order to have various indicators displayed on your dashboard we will now see how to create the associated query and add the chart

1. Go to to your TFS Team Project with your favorite browser
2. Click on the Work tab, then select the Queries sub tab.
3. On the left of the Shared Queries click on the mouse over arrow and select New Query.
   
4. Create and save the query as shown below :
5. 
   Just 3 lines with:
   • Area Path : Select the area path of the team you want to monitor
   • Work Item Type : Product Backlog Item as they hold the effort
   • State : New, Committed and Done. You can replace New by Approved if you use it to effectively tag the PBIs approved by the PO to be in the backlog.
6. Go back to your TFS Team Project home page (top left). And click on the green plus icon at the bottow right of the screen. (mouse over the blue pencil to see it).

   

   Go to to your TFS Team Project with your favorite browser
7. Click on the Work tab, then select the Queries sub tab.
8. On the left of the Shared Queries click on the mouse over arrow and select New Query.
   
9. Create and save the query as shown below :
10. 
    Just 3 lines with:
    • Area Path : Select the area path of the team you want to monitor
    • Work Item Type : Product Backlog Item as they hold the effort
    • State : New, Committed and Done. You can replace New by Approved if you use it to effectively tag the PBIs approved by the PO to be in the backlog.
11. Go back to your TFS Team Project home page (top left). And click on the green plus icon at the bottow right of the screen. (mouse over the blue pencil to see it).

    

1. Select the Chart for Work Items widget and click on Add.

   

   
2. Fill the configuration with the following
   

   

   
   Select the previously created query and the Stacked area chart type.
3. Scroll and fill the remaining as below then click on Save
   

   

   
   Stack by : State
   Values : Sum of Effort
   Range : Last 12 weeks
   Sort by Descending Value

Congratulations you now have a release burnup on your dashboard.

From this basic query you can also create those charts :
Work By Team > Segregate by Area Path
Cumulative Flow > Count Product Backlog Items instead of have a Sum of Effort.