Azure Devops Rollup column Data Calculation Using Analytics service

Question

Hi All,
This is Regarding Azure DevOps.

I am Integrating Azuredevops with ServiceNow application.

As Per the Above image, I am using "Progress by All workitems", "Progress by story Points" columns on my Backlog page.

https://learn.microsoft.com/en-us/azure/devops/boards/backlogs/display-rollup?view=azure-devops&tabs=agile-process

From this documentation, I have understood that "Rollup column data is calculated from the Analytics service."

I want to get the values of "Progress by All workitems", "Progress by story Points" column values for all the workitems within a project through some API call.

Please help me to understand what is the exact Analytics API used on this page and what we need to use, to call the analytics service to get the rollup column data for the above two columns we needed for project work items.

if it is not an API, let me know the query used.

Answer 1

This data is coming from AS so the core APIs I don't believe will work here. In theory you could create a query and call it but queries don't allow rollup columns, at least in the UI. Maybe you could use WIQL in the API, haven't tried. Charts would also be an option.

I really think you're just going to have to switch to the BI integration and query the data directly. You can find the docs here.

Answer 2

Thank you for reaching out! Azure DevOps and its services are not supported in Microsoft Q&A because the Azure DevOps team and DevOps community are actively answering questions here:

https://developercommunity.visualstudio.com/spaces/21/index.html