Work Item Charting is a new light weight reporting feature introduced in Team Foundation Server 2013. Work Item Charting enables users to create visual representation of data for the results generated by Work Item Queries.
Currently, this feature is available in Web Access portal and supported only for Flat Queries.
You can either use an existing default query or you can create a new query and save it in Team Foundation Server to generate the charts. To create a chart you need to go to the Work Items section in web access, double click on one of the saved query, click on the charts tab and then click New Chart option.
It will launch the Configure Chart Window and it displays 5 different types of charts which can be created.
To generate the Pie, Bar and Column charts, you need to provide a value for the Group by Field. By default, below are the listed values for the Group by field.
- Backlog Priority
- Assigned To
- Remaining Work
- Work Item Type
These above values coming from values available under “Selected Column” option which can be launched by clicking Columns option in Work Item Query tab.
Additionally, you can sort the values for all the charts by specifying values for the Sort field. Below are supported values for Sort Field.
In below pie chart, I have selected state as the value for Group by field to generate the chart.
Below is a Bar chart which is created with Group by field value as State.
Below is a Column chart which is created with Group by field value as State.
Stacked Bar Chart:
This chart has Rows and Columns as fields to generate the chart. Both Row and Column fields populates the values based on the selected columns value defined in work item query.
Pivot Table Chart:
This chart also has Rows and Columns as fields to generate the chart.
I hope this post will help you to understand the work item charting in Team Foundation Server.