Azure Devops Query to find Daily hours spent on Work item
I have to find out time spend by a resource on a Task.
let say,
- There are 3 Task (Task-A,Task-B,Task-C)
- There are 3 User (User-A,User-B,User-C)
- All the Task have Original estimate of 8 hours
- on Day 1 All the User have work 2 hours on their respective tasks
So I should get a result of 2
I am using Azure Work Item query to calculate and display the results.
I am not understanding what should be done to calculate the daily work done on a task.
Answer
Azure Devops Query to find Daily hours spent on Work item
AFAIK, Azure devops does not focus on micromanaging and focus on low value metrics.
So, Azure devops doesn't track the time spent on a per day basis. It keeps track of the total time spent. If you want a per person per day value, you'll have to go through the iterations/workitem history and calculate the running difference.
If you really looking for a TimeReporting for the work items of per person, I suggest that you take a look at a third party yool like Timetracker:
New to version 5.0.! Individual, team, and custom reports powered by version 3 of the REST-based reporting API. 7+ customizable widget types that let you see data that you need, how you need it. In addition to the six default reports in Reporting, users can create custom reports for individuals or teams.
Hope this helps.