question

RishiKumarGuptaTadikamalla-7285 avatar image
0 Votes"
RishiKumarGuptaTadikamalla-7285 asked kobulloc-MSFT answered

Azure Devops Rollup column Data Calculation Using Analytics service

118990-screenshot-2021-07-29-at-53046-pm.png



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://docs.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.

not-supported-azure
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

cooldadtx avatar image
0 Votes"
cooldadtx answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

kobulloc-MSFT avatar image
0 Votes"
kobulloc-MSFT answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.