We have Features and Master Features work items. Master Features are parents of Features.
Both the Master Feature and the Feature have the same 3 fields that have values between 1 and 10.
Value to Business
Complexity to Build
Clarity of Requirements
We ONLY want to enter these values for Features, but have an average of these displayed for Master Features. For the Features we will input these manually (as shown). We would like the Master Feature for the child Features to have an average of the values of it's children (see attached diagram).
We also have a VCC column that is calculated from the 3 fields above.
VCC = [Value to Business] + [Clarity of Requirements] + 10 - [Complexity to Build]
For the Master Feature, the VCC value could EITHER be an average of it's childrens values, or calculated from the 3 fields of itself - which ever is easier.
We would like to be able to configure this functionality to hook up other fields or rename fields when needed or change the calculation for how VCC is calculated. Perhaps an XML/JSON configuration file.
My assumption is that it would be an Azure function (Node.js or C#) that reads the VSTS API and updates the values from a webhook. Your response should include instructions and your source code will need to be added to our VSTS instance.
Preference given to developers with good English, non-generic responses, explain their proposed solution (a few sentences is fine), and are available for daily 15-minute calls for the duration of the development between 9am and 10am UK time (we have other similar projects for Visual Studio, VSTS, that you could also potentially do).
PLEASE OUTLINE HOW YOU WOULD GO ABOUT IMPLEMENTING THIS SOLUTION TECHNICALLY.