1

In order to find some Agile Metrix of the project in Azure DevOps (ADO) from last month or from last 2 sprints, I was trying to Query data from ADO like:

  • When a user story was committed and reach to done state?
  • How long a developer took on a user story before it turned to QA?
  • How much time QA took after receiving it from Dev?
  • How many Dev and QA have worked on a user story and how long? Compare that number with the estimated time given at the time if sprint planning.
  • How many time a user story been returned back to Dev for any reason like not fulling Acceptance Criteria, etc? ...

In ADO, I can query the current data, however, there is no way to find historical data from State Graph, History, Discussion!!! I want to find out if the User Story has gone through multiple resources, how much time each of them have spend on that!

Can someone please give me some direction? Thanks in advance.

Leo
  • 315
  • 1
  • 3
  • 17

2 Answers2

0

You can get the historical data using Analytics Odata API. For below example using WorkItemRevisions entity set to load all the revisions for a given work item

https://analytics.dev.azure.com/{OrganizationName}/{ProjectName}/_odata/{version}//WorkItemRevisions?
  $filter=WorkItemId eq {Id}
  &$select=WorkItemId, Title, State

Then You can Run the OData query from Power BI to create a PowerBI report. Also see document Power BI integration. Please check example Calculate time-in-state.

You can also use rest api to get historical data of a workitem. See below:

Revisions - List

Comments - Get Comments

Updates - List

Levi Lu-MSFT
  • 27,483
  • 2
  • 31
  • 43
0

For querying historical data of single workitem you can use this chrome extension - https://chrome.google.com/webstore/detail/azure-devops-workitem-inf/ociekhbkajgbjdenikmandhpjlekckee.

There you can see changes of any field, and also you can see how many time the field was in particular state.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Alexey Totmakov
  • 1