19Sep

VSTS Rollup Service - Setup

Hi All, if you are worrying how to calculate sum of the effort fields in VSTS, here is the solution. I’m going to explain you how our VSTS Rollup Service works. Here is the entire thing you need to know.

VSTS Rollup is a Web Service which provides summed values of select fields for all child work items of a parent. Most project managers are interested in getting rollup of estimated or completed work, effort etc. Hence Rollup will automate the process of summing up the Effort fields, viz., Original Estimate, Remaining Work and Completed Work from child work item Tasks and show it at Requirement level, in the same fashion show summation of effort fields of all child Requirements (PBI/User Story) at Feature level and continues for Epic level.

Rollup service also does the calculation of effort fields.

  • While creating a Task, you should just enter the value into Original Estimate field, the  Remaining and Completed work will be updated.
  • When you update a Task with Completed hours, remaining work is automatically calculated based on the formula Original Estimate - Completed Work = Remaining Work.

vstsrollupSignUp

Before you start

Below are the pre-requisites to get your VSTS Team Project registered for this Rollup web service.

  • You will need a Visual Studio Team Service (VSTS) Account - if you don't have, you can create one now.
  • You will need a Personal Access Token (PAT) for the account. An overview of Personal Access Token with instruction to create are available here.
  • Create the web service hooks using the tool, please refer the below section.
  • Once the web service is created using the tool, test the service hooks once to activate them. please refer below section.

Now click on the  Sign in with VSTS credentials. if you have not signed in to the VSTS account in your browser, it will be redirected to sign in page. Provide your credentials.

 

signin

 

Fig 2. Sign In page.

If you have already signed in to the VSTS account in your browser, it will be redirected to Grant access page. Rollup requests these accesses from the user account.

signedin

Fig 3. Grant Access

Once you click on accept it will take you to account selection section, where all VSTS account associated with your ID will be loaded. Select an account and provide Personal Access Token(PAT) associated with that account and click on continue button. If you don’t know how to create PAT, click here.

account_select

Fig 4. Account Selection

Once you click on continue, service internally validates for the account and the PAT provided, if it validates to true you will be redirected to project selection page, which will be loaded based on your account selection.

project_selection

Fig 5. Project Selection

Select a project from the list and click on Create Service Hooks button, which intern takes a few seconds to create service hooks for Work Item create, Update and Restore. You can click on the link provided in the success message and check for the service hooks created.

Success

Fig 6. Success message with link for service hooks page.

service_hooks

Fig 7. Service hooks created.

Please activate your service hooks as the steps provided below.

Step 1. Click on Ellipse (…)

ellipse

Step 2. Click on Edit

Edit

Step 3. Click on Next in your Trigger dialog.

trigger1

Step 4. Click on Test in your action dialog.

action1

Step 5. Test Success

testSuccess

Repeat the same steps for the remaining service hooks and activate them.

Rollup service internally creates a Dashboard to show the Rollup values and a Rollup View Query in the Shared Query folder. Below us RollUp Dashboard.

Dashboard

Fig 8. RollUp Dashboard

query

Fig 9. Rollup View Query.

Finally you are ready with Rollup service setup. Please look into next blog - VSTS Rollup Service - How to use.

Related

Roles in DevOps Mobile App Development

DevOps can be defined as an approach to enable seamless application delivery from inception to produ...

Read More >

How to Prevent Users from Moving Task to Closed State with a non-Zero value Remaining Work field in VSTS/TFS

In this Blog I am going to explain how we can customize Task in VSTS/TFS to Prevent Users from Movin...

Read More >

DevOps with Visual Studio Team Services for Java

Hi All, if you are worrying how to do DevOps for Java in VSTS, here is the solution. I’m going to e...

Read More >

Implementing Security to your DevOps Pipeline

Hi all, today in this post I'm gonna talk about "Implementing Security to your DevOps Pipel...

Read More >

VSTS Rollup Service - How to use

          Hi All, Here i'm going to explain How VST...

Read More >

VSTS Area Uploader

VSTS Area Uploader helps you to upload Areas (with multiple level) to your VSTS Team Projects from a...

Read More >

VSTS Copy Dashboard Tool

The Copy Dashboard tool replicates/copies the existing dashboard from one team to either single or m...

Read More >

Dashboard Migrator Tool

This is a web service which helps you to copy the VSTS dashboards from 1 team to another team easing...

Read More >

VSTS Team project Monitor

Let us discuss how to install VSTS team project monitor and how we can make use of it easily.Particu...

Read More >

Canarys Automations Pvt Ltd recognized as finalist for 2017 Microsoft DevOps Partner of the Year Award

  Bengaluru, Karnataka, India — June 2, 2017 — Canarys Automations Pvt Ltd tod...

Read More >

Share

Comments

Original Estimate - Completed Work = Remaining Work is a little to simplistic an equation for something like this as you could estimate 4 hours for something, complete 5 hours and still need to do 3 hours of work. In this case you will have -1 hours remaining instead of 3. This will mess up the burndown chart as it will show that you are doing better than you are doing much better than you really are.. I would say that you could just alter the original estimate, but it is important for future planning to allow you to know what you thought it would take and what it actually did take. The automation of this is nice, but I think it is being done in an overly simplistic way.
10/4/2017 10:08:39 PM | Reply

Post a Comment

  • Recent
  • Popular
  • Tag
Monthly Archive
Subscribe
Name

Contact Us
  • *
  • *