How can we improve Team Services?

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.

14 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Brien ChristesenBrien Christesen shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base