calculate effort in sprint on specific dates

0
votes

I am using TFS 2012. I am using TFS reporting (SSRS) to prepare scope creep report. My requirement is to display 4 columns(data) in chart for each sprint:

  1. How many effort was planned on first day of sprint?
  2. Any effort added between second day and last day of sprint?
  3. Any effort removed between second day and last day of sprint
  4. How many efforts were completed in sprint.

I am taking reference of "Velocity" report The "Velocity" report definitely solve 4th requirement but I am struggling to resolve all requirement in single report. I am not very much aware of MDX queries and don't know what to add or modify in existing dataset of "Velocity" report to get desired result. I am struggling to extract specific dates of sprint and use them to calculate effort on these dates. How can I do it?

1
reporting-servicestfsssrs-2012
Unlike forum sites, we don't use "Thanks", or "Any help appreciated", or signatures on Stack Overflow. See "Should 'Hi', 'thanks,' taglines, and salutations be removed from posts?. - John Saunders

1 Answers

0
votes

You can use the TFS API to run an "as of" query in WIQL to get the data that you want. That is how both the burn down and velocity charts are built in the web UI.