Can I create a Customer Number field with entries based on a calculation using other Fields?

Russ Willis April 16, 2024

Hi there, I am a JIRA Administator / Manager with no training in JIRA Administration.  I have joined a FinTech that uses JIRA Cloud.  It has almost 1000 tickets in it's current Backlog.
   Thus, for a first step to managing this Backlog, I want to create a Custom Field ("Value Effort") that uses a ticket's Total Delivery Value divided by it's Effort Required to Deliver (an oversimplification, but you get the point) and automatically assigns a "Value Effort" number to each ticket.

   We have the (estimate) fields related to Total Delivery Value, and Effort Required to Deliver on our User Stories.  Thus, I need to configure the Custom Field of "Value Effort" and base it's automatically derived value on an equation using the existing fields.

   Now, my question:  Can this even be done with JIRA Cloud (not Premium)?  Do I need Add-Ins, if so?

I have looked in the Custom Field configuration and see how to set up the Field and assign it to Screens, but I see nowhere to imbed an equation to be used in automatically deriving the value of this "Value Effort" field.

   Thank you for any insight you can provide.

3 answers

2 votes
Reshma Begum _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2024

Hello @Russ Willis ,

Our JMCF app provides scripted fields with which you can perform calculations like division on custom fields.

You can install a trial version of our app from the marketplace and create a Scripted Number field with the script below. 

const effort = await api.issue.getField(issue, "customfield_10141")

console.log(effort)

const deliver = await api.issue.getField(issue, "customfield_10140")

console.log(deliver)

if (effort !== null) {

const res = deliver/effort

return res.toFixed(2)

}

Make sure to modify the custom field IDs of Total Delivery Value, and Effort Required to Deliver fields in the script above. 

Please see our documentation on scripted fields for more details.

Please feel free to open a support request from here if you have any questions.

BTW, I am from Appfire, a vendor of JMCF.

Thanks,

Reshma

Russ Willis April 17, 2024

Cheers Reshma.  I'll check this out.

Like Reshma Begum _Appfire_ likes this
2 votes
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 16, 2024

Hi @Russ Willis,

Welcome to Atlassian Community!

It can be done with automation, but on the standard plan you are limited to 1700 runs per month, see this KB. So you would either have to go to Premium or use one of the scripting apps available in the Marketplace. I have used both Scriptrunner and Power Scripts in the past and both can do this.

Russ Willis April 17, 2024

Thank you Mikael.  Does "1700 Runs" mean executing the Script once and it applies the calculation for all Backlog items, or does each Backlog Item count as a single Run?  

1 vote
Jehan Bhathena
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 16, 2024

Hi @Russ Willis 

You can try this https://help-seibertmedia.atlassian.net/wiki/spaces/ACF/pages/77037570/Advanced+Formula

It's a free plugin so won't cost you for learning it out. 🙃

Russ Willis April 17, 2024

Thank you Jehan.  I'll look into this.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events