nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Complex Calculated Fields

Greg Bammel

What is the best way to create a custom complex calculated field? For example, I have fields priority and severity. I wanted both priority and severity to map to a number. The calculated field should be the multiplication of those two fields? Is this possible? If yes, what is the best way to tackle it?

Accepted answers

Mikael Sandberg

Hi @Greg Bammel,

Welcome to Atlassian Community!

You have a couple of options to do this. You could use automation to do the calculation via smart values and math expressions. Another option would be to use something like Scriptrunner, it has calculated fields that you could use or you could write a script that does the calculation. Back in the days when I was on Jira Data Center I created a Scriptrunner script that calculated three different fields to get a risk value.

All comments

Mikael Sandberg

Hi @Greg Bammel,

Welcome to Atlassian Community!

Riley Venable

You can use the arithmetic operations mentioned in the context to create a custom complex calculated field. For example, you can set the custom field to be the multiplication of the priority and severity fields by using the expression "{{Priority}} * {{Severity}}".

Vincent Mutambuki { Mumo Systems }

You can create use Abacus to create a formula with two custom fields and a results fields as shown below.

Screenshot 2023-03-03 at 3.40.02 PM.png

Then create an execution plan and use the map field values action to map Priority values to numbers. Make sure to store the value to the MappedPriority number field you created in the formula above.

Add another map field value action to map severity values to numbers. Lastly, add you formula which will use the mapped values to do calculations based on the issue event trigger you select.

Screenshot 2023-03-03 at 4.01.14 PM.png

Disclosure - I represent Abacus vendor. This is not intended to be a commercial but to solve a this problem. Use it at your will.

Bill Sheboy

Hi @Vincent Mutambuki { Mumo Systems }

When recommending a marketplace vendor product, please ensure you disclose your affiliation to that vendor in your post wording. For more information about this, please see:

Atlassian Community online guidelines for Marketplace and Solution Partners

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Atlassian-Community-online-guidelines-for-Marketplace-and/ba-p/689723

Kind regards,
Bill

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud