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.
From the Queries page, open the chart editor for a flat list query. To author charts, you need to have Advanced access.
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.
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.
Choose Sort-by-Value to display data based on numeric values; descending will display the largest data values first. Choose Sort-by-Label to display data based on labels; ascending will display grouped data according to the alphabetical order.
If you receive an error message when you close the chart editor, you need to request Advanced access.
Charts automatically update when you edit the query and when the results of the query change.
A: You need to have Advanced access in TWA to create and save charts.
A: Feature support for changing chart colors is available in Visual Studio Online and for TFS instances that have been upgraded to TFS 2013.2. Simply select a series in the chart and pick a color from the color picker. The TFS 2013.2 download is available here.
A: Feature support for pinning charts to the team home page is available in Visual Studio Online and for TFS instances that have been upgraded to TFS 2013.2. To edit, delete, or pin a chart to the home page, select an option from the chart's context menu. You can only pin charts to the home page that are saved as shared queries.
To learn more about the team home page, see View progress on the team dashboard (home page).
A: 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.
A: Yes, if you connect to a server that has been updated to TFS 2013.4. Otherwise, you can only create status charts that show a count of work items.
To create trend charts, open the query in Team Explorer and choose Create Report in Microsoft Excel.
A: The chart editor generates 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.
A: You can access the following charts:
From TWA you can access the cumulative flow diagram, team velocity, and sprint burndown charts from the backlog and sprint backlog pages. In addition, you can create charts that track test progress and test results.
If your on-premises TFS deployment and team project have a project portal and SharePoint site configured, you can access several Excel charts. These include charts to monitor code quality, testing, and bug tracking activity.
If your on-premises TFS deployment and team project have SQL Server reports added, you can access several reports that include status and trend activities. If you need to add reporting, see Add reports to a team project.
If your on-premises TFS deployment has reporting services added, you can create an Excel chart from a work item query.