Is there a way to create a Risk Score based on the Probablility times the Impact of the Risk?

[stephan_lewis]

This gets a bit more complicated in that the Probability and Impact fields contain both Text and a Number (1- Low, 2- Low-Medium, 3 - Medium, etc.)

I wanted this all in Jira so that I could have a real time Risk Register in Confluence.

I couldn't figure out a way to do this in Jira so I tuned to Smartsheet to come up with a solution. However I need to run the Jira connector to update my sheet (yes there is supposed to be a 2 way live connector - but I've never had any success with it).

Any thoughts?

[Walter Buggenhout · Accepted solution]

Hi @stephan_lewis,

Make sure you have 3 custom fields available in your Jira project: probability, impact and a risk score. Create an automation rule to calculate the risk score at each change of one of the other fields.

Your automation rule could use Field Value Changed as its trigger (referencing both fields). Use lookup tables to translate the options from your custom fields to numbers for your calculations.

Hope this helps! 

[stephan_lewis]

ohh - never used Lookup tables

I will check it out 

Thank you so much!

[stephan_lewis]

Lookup tables are great - easy to set up.

I created two lookup tables; ProbabilityValue and ImpactValue.

The tricky part was getting the Smart Value formatting correct.

If your custom field has multiple words you need to use quotes around them.

{{ProbabilityValue.get(issue.Probability)}} * {{ImpactValue.get(issue."Impact of Risk")}}

It works great if both the Probability and Impact of Risk have values. However, if one of them is missing then it throws an error.

Edit issue: Could not convert the field value to a number. Please ensure the value is a number, math expression or smart-value that can be converted into a number.

Makes sense; can't mutiply without 2 values.

Have to put in a check for values and bail if they aren't both there. Haven't done this type of check - but hopefully it will be easy.

Thanks for your help,

Stephan

[John Funk]

Hi @stephan_lewis  - can you post your final rule, especially showing the details of the lookup tables? That will help future readers of the post. 

[Maksym Babenko]

Hello @stephan_lewis 

Yes, you can calculate a Risk Score in Jira by multiplying Probability and Impact values, but Jira doesn’t natively support calculated fields.

A workaround is using Risk Radar, which automatically evaluates risk based on key parameters, including Probability and Impact. It keeps everything in Jira.

Let me know if you’d like more details!

[stephan_lewis]

[John Funk]

Thank you!

[Bachir AMMACHE]

Hello !

I did the same thing but it is not working for me , 
P.S : My Impact and Probability fields are only text field (dropdown values) Low , Medium, High 
I did 2 lookup values but still nothing works , 

[stephan_lewis]

Did you create a Risk Score custom field?

[stephan_lewis]

Did you create a Risk Score custom field?

[Bachir AMMACHE]

Yes I did , but the thing is that my probability and impact risk are dropdown custom fields ( with icons red/orange/ green circles) and I can not add these icons to the lookup table .

The rule works well when I change the fields from dropdown to text fields , but I really need to show the emojis ...

[stephan_lewis]

oh - can you change them to number fields instead - just to see if it works?

Not sure how to address the icons.