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

Custom formula point error when using newly created rating field

신준오_Johnny_
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!
September 1, 2024

 

If I select the newly created rating field, the score is not calculated in the custom formula based on the selected rating.

 

1. These are the current custom formula settings.

 

Setting.png

 

2. There are two severity fields, one of which is a new field I created.

 

1.png

 

3. If I set the original severity to "Very Low," 20 points will be assigned. I believe this is normal.

 

2.png

 

4. However, if I set the newly created severity to "Very Low," 100 points are assigned.

3.png

 

 

1 answer

1 accepted

0 votes
Answer accepted
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 2, 2024 edited

Hi, that's actually expected. See details here: https://support.atlassian.com/jira-product-discovery/docs/expression-based-formulas/

here's how it works:

  • for each field, the formula plots each idea on a 0-100 scale (the idea with the lowest field value gets 0, the one with the highest value gets 100, the others are plotted in between)
    • So, in your case, the idea with "severity new = 1" gets 100, all the others with no value get 0.
    • And the idea with "severity = 5" gets 100 as well
  • Then the weighted score gets calculated. In your case, both "severity" and "severity new" get equal weighting. So they land with the same score. 

This works well when you have fields of different scales, for example one field with a 1-5 scale and another one with a 1-100 scale. But I agree that in your case it can look weird.


As an alternative, if every field you have is a 1-5 scale, you could use a formula of type "write your own": 

Score = Business * 25 + value * 25 + severity * 25 + {severity new} * 25

(or simply Business * value * severity * {severity new} since all options have the same weight)

And then you can create a formula of type "weighted score", which takes only one input (Score).

I think this would work better for you.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Upcoming Jira Product Discovery Events