Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Missing exponent function in a custom forumla (=power of n)

Daniel Rijkhof
November 25, 2022

I just love product discovery! Lately i'm automating calculating priority of ideas. I'm doing this based on 'Custom Formula' fields with 'write your own' expressions.

I have found the page that describes what we can do with expression based forumlas: 
https://support.atlassian.com/jira-product-discovery/docs/expression-based-formulas/

I'm however really missing the option to do x to the power of n (x^n):

Why do i need it:

The field weights are ranged 0 to 5 (with 0 the field not being filled).
To make higher values worth more, I need to move from a linear set of values to an exponential set.

Consider the readability of my current solution vs my preferred solution: 

Current:

{__impact_0to1}*(1-({__effort_0to1}*{__effort_0to1}*{__effort_0to1}*{__effort_0to1}))

Wanted:

{__impact_0to1} * (1 - {__effort_0to1} ^ 4 )

Question:

Perhaps this is possible already but not documented, or done differently.

In that case, please tell me how to do this. If not, perhaps add it to the backlog?

2 answers

1 accepted

2 votes
Answer accepted
Denis Paul
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 Champions.
March 7, 2024

You cannot tell the score of a single item as this is a relative measurement compared to other ideas

see this support article 

What is normalization?
Normalization is an operation over the field values across all ideas:

0 is the lower value, or we use the lower one if there is a negative value. 

The highest field value is 100.

All values are then plotted based on their relative value between those two. 

Example

Idea 1 has rating 4/5 results in impact 100

Idea 2 has rating 3/5 results in impact 75

Idea 3 has rating 1/5 results in impact 25

And this will change as soon as you add another idea!

Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 7, 2024

Yep, that's how it works! This is a default field we included in the default project configuration, but you can create your own formula field, or change the configuration of this one, if you don't like how it works. 

 

E.g. if you'd rather have an absolute number (vs a relative one) you can create a formula of type "write your own" (Fields > Create a field > Formula field). And there you can do things like Impact / Effort.

Santhosh Raj
Contributor
March 11, 2024

I mean I was asking like a sample mathematical calculations example.
So it would be very helpful for me and I'll try to make some new formula based on your ideas, Weightage like that.

@Tanguy Crusson  @Denis Paul 

I want to know how it calculates and If i can have a manual, I will be working based on that.

But thanks for the article @Denis Paul 

Denis Paul
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 Champions.
March 11, 2024

As far as I understand your question the formula could be 

Impact + Goal
----------------  = Score
    Effort

So the score from your example is (3+2) / 1 = 5

 

Like # people like this
0 votes
John Funk
Community Champion
March 7, 2024

Hi Santhosh - sorry but I am I not user of Jira Product Discovery, so not sure how the calculations happen. 

Santhosh Raj
Contributor
March 11, 2024

Sorry @John Funk .

Like John Funk likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events