Canarys Rollup

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

• Azure DevOps Organization and Project
• Admin access to the project in which you would like to configure the Service Hooks
• A valid Personal Access Token (PAT) with following scope
  • User Profile Read
  • Work Items Read and Write

The PAT would be used in Web Hooks, 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 Web Hooks

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, also you can opt for Story Point Rollup.

Web hooks can be seen in the respective project settings >> Web Hooks page

Features

1. Effort field values of child work items are rolled up to parent work item fields.
2. Auto Calculate Remaining Work based on Original Estimate and Completed Work.
3. Story Point Rollup.
4. RollUp View Dashboard based on the process template selected for the project.

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".