Calculate a strategic score

Felix van Dijk

I am looking to create a "Strategic Score" for a project which will determine its place on a roadmap. This score is made up of 4 to 6 values given by the person submitting the project (almost like an ICE scoring). These provided values are then multiplied by a "weight" for each which the manager of the roadmap determines. 

I can do this via automations but what I am needing help with is to make the "weights" of these scores available on a Project level which will affect all Issues in that project alike. I also need to show these "weight inputs" somewhere central so the manager can change them and adjust them without accessing the automation calculation which isn't easy for non technical users. 

 

As an example: 
{{Impact_value*Impact_weight}}+{{Value_value*Value_weight}} = Strategic score

 

John Funk

Hi Felix - Welcome to the Atlassian Community!

This is not an easy problem to solve because you can't do Project level fields. One way to solve it is to create a custom field of number type - default it to 0. Then create an issue on each project that is specific to get those values. Maybe even create a new Issue Type like Project or Strategic Score or something like that. This is the issue that your managers will update on each project. 

But you will need to link every issue you create on the project to that issue so you can retrieve the values. Or if your issues where you are calculating the score will not use Epic or other wise utilize the Parent field, then you could create score issue at that level and use it more simply to pull in the value. 

Then update your automation to retrieve that value. If it's a parent that is an easier smart value to write. Or you could make use of lookupIssues functionality to get the parent and use the score value in a variable.