Search code examples
azure-devopsscrum

How can I pull a report of effort by person in Azure DevOps under the Scrum template?

In Azure DevOps, I need to pull a report of the work done by person in order to distribute payments between team members.

Solution

  • Since the VSTS does not support rollup of the Effort directly:

    enter image description here

    I suggest you use query to pull out the report of effort for all teams first, then download this report and roll up the effort by person.

    • Step1: Go Query page, then add Effort column by open Columns Options:

    enter image description here

    Note: This steps is very import, this can help for pull out a report which contains the Effort field.

    • Step2: Create a query like below shown:

    enter image description here

    In the value of State, just input the states which represent the work done in your project. For me, there has 2 states can represent the work has been done: Done and Closed. For Assign to, you could specify the group(s) name which cover the all person you want to check in value blank.

    • Step3: Download this into CSV by using the button Export to CSV:

    enter image description here

    • Steps4: The above step would generate a excel in local. Then you could apply the Pivot table into that to count the effort by person.