Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Jira Product Discovery calculated fields based on selection

Mazen ElAasser July 20, 2023

I am using a Jira Product Discovery, I have several fields, for example, MAUs field (number), Financial impact field (number) and Risk field(Text), how can I make the options that the people choose translate into a total score in a different field, for example if people put a number that is less than 100 in financial impact field it will give a score of 1, and then if they choose low risk from the Risk field options they get another score of 1 and then if they choose a number larger than 250 in MAUs filed they get a score of 5 and all of this gets summed up in a total score field?

 

I am aware of some plugins but my admin can't authorise the use of them so I am looking for some sort of workarounds.

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
1 vote
Answer accepted
Bill Sheboy
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.
July 20, 2023

Hi @Mazen ElAasser 

Based upon the complexity of your calculation, you may be able to use the built-in custom formulas feature of Jira Product Discovery: https://support.atlassian.com/jira-product-discovery/docs/expression-based-formulas/

If that will not handle your use case, you could perform more complex calculations using the built-in automation for Jira rules: https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/

Kind regards,
Bill

Ingo Wenke July 20, 2023

Hi @Mazen ElAasser ,

as Bill mentioned, automation is a good tool to implement your rules. We use automation to calculate the WSJF and it works fine.

Have fun

Ingo

Like Mazen ElAasser likes this
Richard Kirk
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 21, 2023

On the principle of keeping it simple to start with, I'd go with @Bill Sheboy 's suggestion of using a custom formula:

jpd_1.png

with a type of weighted score and adding your 3 fields as positive inputs:

jpd_2.png

Like Mazen ElAasser likes this
TAGS
AUG Leaders

Atlassian Community Events