Allow charting on fields other than "count of work items" such as effort or work remaining
When creating a chart based on a TFS query, the only option for Values is "count of work items." I would like to create a pie chart grouped by state where the value of each sector is the total effort for the work items in that state.
Have a look here: https://msdn.microsoft.com/library/dn407521%28v=vs.120%29.aspx, scroll down to the question:
Q: Can I create a chart that aggregates items using SUM? Can I create a trend chart?
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.