Canarys RollUp is a web service which runs in the background with the help of trigger based work item events, like work item create and update events.

The service helps you to configure the webhooks in your project settings, which triggers the RollUp service. Based on the request received, the RollUp service would Sum up the Effort field values of child work items, namely - Original Estimate, Completed Work and Remaining Work and updates consolidated values in the parent work item fields.

We have an optional feature to Auto Calculate Remaining Work as well. Based on the Entered values in Original Estimate and Completed work, remaining work will be automatically calculated and updated to the parent work item.

Prerequisites to configure the RollUp service

1. Azure DevOps Organization and Project

2. Admin access to the project in which you would like to configure the Service Hooks

3. A valid Personal Access Token (PAT) with following scope

   • User Profile Read
   • Work Items Read and Write

The PAT would be used in WebHooks, which will be used in processing incoming work item request to RollUp service.

Authentication

RollUp service should be authenticated with OAuth Authentication, which requires to enter your Azure DevOps organization credentials, and provide the consent to complete the authentication process.

Configure WebHooks

Once you accept the consent, you will be directed to Configure RollUp service page. Select your Organization and the Project, provide the PAT generated.

If you would like to calculate the Remaining work automatically based on the entered Orginal Estimate and the Completed work, select the radio button Yes or No.

By default option will be selected as Yes

Click on the configured service hooks link, you will be navigated to the project where the WebHooks are configured, notice that webhooks are pointing to the application where the RollUp service is hosted.

RollUp View Dashboard

RollUp service has configured a Dashboard - RollUp View and a Query with the same name to show the values that are Rolled up at parent level.

Share your experiences, feature requests and feedback on our email vststoolssupport@ecanarys.com with the subject line "Canarys RollUp".