Calculated Fields in Jira

[M Vijay Kumar]

Hi All,

I have two fields Risk score and Risk severity which are associated to risk issue type. Risk score is a calculated number field which is configured as multiplication of impact and probability. 

i was able to successfully configure Risk score, the next requirement is  i would like to select the risk severity which is a single select based on Risk score. For instance: 

if Risk score is 1-10 then severity is low

10-20 then it is medium 

20-30 then it is high, i would like to know whether we can achieve this in jira. Any help provided will be really appreciated.

Thanks,

Vijay

[David Pinn]

Have you seen Risk Register for Jira?

Disclosure: I'm the vendor.

[M Vijay Kumar]

Can we achieve this with out add-on ? 

[Nic Brough -Adaptavist-]

No.  There's no functions for scripted or calculated fields built in. 

The Risk Register David mentions is specialised for risks and fits your case very well.  It may be worth a look at other scripting add-ons if you have other calculations to do though.

[Johnson Wang]

Hey @M Vijay Kumar,

Unfortunately this kind of calculation and dependency between fields can't be done in JIRA without using add-ons.

If you are open to trying an add-on, I'd recommend Power Scripts. With just a few lines of code, you can perform your risk scoring.

Here's a short video guide that shows a very similar setup for doing field calculation. You'll need to customize with your algebra and custom field numbers.

And here's the sample script:

//Calculate the issue score//Used by customfield_10702 -  Issue Completeness Score int score = 0; if(isNotNull(assignee)) {    score += 10;}if(isNotNull(dueDate)){    score += 10;}if(isNotNull(description)) {    score += 10;} if(score < 10) {    return "Bad";}else if(score >= 10 and score < 20) {    return "OK";}else if(score >= 20 and score < 30) {    return "Good";}else {    return "Great";}

Hope this helps!

Johnson