Table of contents

Charts

Last Updated: 8/12/2016

Team Services | TFS 2015 | Previous versions

You can quickly view the status of work in progress by charting the results of a flat-list query. You can create several types of charts—such as pie, column, or trend—for the same query.

Charts support viewing a count of work items or a sum of values for select numeric fields, such as Remaining Work or Original Estimate.

A view of 4 charts for a flat-list query

Add a chart

  1. From the Queries page, open the chart editor for a flat list query.

    New chart link on Charts page

  2. Select the chart type and field for grouping values. When you use pie, bar, and column charts, select a single field to view a count of work items.

    Configure a Pie chart

    If you don’t see the field you want in the Group by drop-down list, add the field as a column to the query and save the query. You can group by any field except date-time and free-form text fields. For example:

    • To group by iterations, include the Iteration Path in the query or column options
    • To group by team, include the Area Path or Node Name in the query or column options
    • To group by a custom field, include it in a query clause or column options (Go here to learn about adding a custom field)

    If you receive an error message when you close the chart editor, you need to request Basic access.

  3. To sort the results, choose value or label as the sort option and then ascending or descending.

  4. To change a color, simply click a color on the chart and pick a new color from the color picker.

Charts automatically update when you edit the query or refresh the query results.

Stacked bar chart

A stacked bar chart lets you track progress against two field values. Node Name will display the last leaf within the hierarchy of area paths. Use this when you want to show data across teams.

Configure Chart dialog box for a Stacked bar chart

Trend chart

Trend charts let you view progress for the last one, two, or four weeks.

Configure a stacked area trend chart

Burndown chart

Choose the Sum operator for Remaining Work to view a burndown chart of tasks.

Trend chart for the past 4 weeks

Add a chart to a team dashboard

Select your option from the chart's context menu.

Chart context menu, add to a team dashboard

To add a chart to your team's home page, you must be a team administrator. You can only add charts defined for shared queries.

To add other types of charts, such as test results and build summary charts, see Add a chart to a dashboard.

Feature availability: For on-premises TFS 2015, you can pin charts to the team homepage. From Team Services or TFS 2015 Update 1, you can add charts to multiple team dashboards and get access to the widget catalog.

Add chart widget to a dashboard

Feature availability: The Chart for work items widget is available from Team Services or TFS 2015 Update 2 or later version. You add it to a team dashboard from the widget catalog.

If you've already defined your flat list query, you can add and configure a chart to a team dashboard using the Chart for work items widget.

  1. From the web portal for Team Services, open the team dashboard you want to add the chart to.

  2. Click Edit dashboard icon to modify a dashboard, and then click add a widget icon to access the widget catalog.

    If you don't see these icons, then you need to be added as a team administrator or a member of the Project Administrators group.

  3. Click the Chart for work items widget and then click Add.

    Chart for work items widget

  4. Click the widget's Configure widget icon configure icon to open the configuration dialog.

    Chart of work items widget, configure dialog

  5. Give the chart a title, select the flat list query on which the chart is based, and choose the chart type.

    Based on your chart type, specify values for the remaining fields. Change a chart color simply by choosing another color from those shown.

    Note: All rules for configuring charts described previously in this topic apply to configuring the chart for work items widget.
  6. After you save your changes, you'll see the new chart has been added to the dashboard.

    Chart of work items widget, configure dialog

  7. Drag the tile anywhere on the dashboard to put it where you want it.

  8. When you're finished with your changes, click Exit edit-dashboard-mode icon to exit dashboard editing.

Now you know how to create status and trend charts for work items. A few things to keep in mind...

  • To create similar charts for tests, see Track your test results.
  • Charts you create for queries that are saved under Shared Queries are viewable by all team members and can be added to team dashboards or pinned to a team homepage.
  • Charts that you create for queries under your My Queries folder are visible only to you.
  • You can copy and email the URL of any chart page to share it with a team member.

Also, from the web portal, you can view the following charts:

Requirements to view and create charts

If you have Stakeholder access or license, you can only view charts. If you need to create charts, ask your project admin or account owner to grant you elevated access.

Fields that show up in the chart editor

For fields to appear in the chart editor, you must add the field to either the query filter criteria or a displayed column.

You can’t select fields for groupings that aren't supported, such as ID, Title, Tags, date-time fields, Description, Repro Steps, and other HTML and long text fields.

Charts and the display of areas and iterations

When you select Area Path or Iteration Path, only the leaf node appears in the chart. The leaf node is the last node of the full path. For example, Phone is the leaf node of FabrikamFiber/Fabrikam Website/Phone. If your query contains a mixed level of leaf nodes, your chart might not reflect expected results.

Use Node Name, the area path leaf node, to see if that improves your results.

Charts display in browsers that support Scalable Vector Graphics (SVG). This includes Internet Explorer 9 and Internet Explorer 10, Chrome, Firefox and Safari on Mac. Charts have not been optimized for mobile or touch displays.

Why some charts don't show all the field values in the results

When a chart contains more than seven items within the data series, values in the eight-plus items are consolidated into a set labeled “other.”

Other category groups data beyond 7 set series

Additional charts (TFS)

Query-based charts versus Excel-generated PivotCharts

Query-based charts generate data from the work item tracking data store and therefore displays the most recent data. Excel PivotCharts access data published to the Analysis Services cube, which is refreshed every two hours by default. Also, Excel PivotCharts are only available to users of an on-premises TFS.

© 2016 Microsoft