Velocity Chart from Azure DevOps API

[Anonymous]

I'm trying to re-create a velocity chart in Power BI from data in Azure Devops. I'd like it to be based on work item count instead of story points or estimates. Has anyone built something like this? I'm not sure where the best place is to get this info from. I found an article an article on LinkedIn by @ferryv but it is based on estimates on each work item. Thanks in advance for any help!

[ferryv]

It is. See also: https://learn.microsoft.com/en-us/azure/devops/report/extend-analytics/data-model-analytics-service?...

If you want to use it for multiple Azure DevOps organisations, this might help you:

https://www.linkedin.com/pulse/retrieve-data-from-multiple-azure-devops-microsoft-van-der-vorst/?tra...

Can also be used for a single org. 

To simplify this, you could also just use the oData route, see also: https://learn.microsoft.com/en-us/azure/devops/report/extend-analytics/analytics-recipes?view=azure-.... The workitemtype can be retrieved from this too.

[ferryv]

In order to do it by work item count, you need to change this measures in the article that sum up the estimate values to a measure that count the items in e.g. a sprint or area path. For instance, change:

Committed = CALCULATE(SUMX('DataSet','DataSet'[Estimate]),FILTER('DataSet','DataSet'[Area Path]='DataSet'[Area Path]))

to count the number of items. For instance, change it to:

Committed = CALCULATE(COUNTX('DataSet','DataSet'[Work Item Type]),FILTER('DataSet','DataSet'[Area Path]='DataSet'[Area Path]))

 Similarly for the "Average Velocity" measure.

Hope this helps.

[Anonymous]

Thanks @ferryv! What is the best table to pull this type information WorkItemSnapshot?