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).
    tfsaddwidget.png
    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).
    tfsaddwidget.png
  1. Select the Chart for Work Items widget and click on Add.
    tfstaskburndown2
  2. Fill the configuration with the following
    releaseburnupstep1

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

    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.

tfsreleaseburnup

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.

tfs2015charts.PNG

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s