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?

1 answer

1 accepted

2 votes
Answer accepted
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 25, 2022

thanks for the feedback @Daniel Rijkhof , I don't think there's a way to do that today but we'll consider it when improving formulas 

Daniel Rijkhof November 25, 2022

Thanks for the quick reply.

I hope the request to add power of n (x^n) to the options for formulas makes it onto some high priority quick wins list. It cannot be that much work can it 😇

Cheers

Daniel

Jan-Hendrik Spieth
Contributor
November 28, 2022

We'd appreciate a power function, as well. Currently, we're multiplying a lot ... ({effort}*{effort}*{effort} ... ;-))

Daniel Rijkhof November 28, 2022

To do cool stuff we just need that.

Here some examples that are doable with a ^:

Low end boost (low_end_boost: 4)

1-((1-{__ranged_0to1})^<low_end_boost>)

 

image.png

 

High end boost (high_end_boost: 3)

{__ranged_0to1}^<high_end_boost>

image.png

 

Double boost: (high_end_boost and low_end_boost at 3)

({__ranged_0to1}^<high_end_boost>)^((1-{__ranged_0to1})^<low_end_boost>)

image.png

This last example is currently impossible. 

Depending on the distribution of values the last formula can really effectively distribute idea's in a matrix view nicely...

Like Jan-Hendrik Spieth likes this
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 29, 2022

Oh. My. God. Are we still talking about product management and prioritization? 😅 I'd love to chat to understand how that works in your company because there seems to be a hell of a lot more science than what I've seen so far.

Like Steffen Opel _Utoolity_ likes this
Daniel Rijkhof November 29, 2022

I'm very much open to discuss this topic with you! How can we set it up?

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

@Daniel Rijkhof by the way you can now give custom weights to options in a select/multi-select field (not just use a 1-5 rating but use any number you like in there). 

I remember you wanted this pretty badly. let us know if that helps!

Like # people like this
Daniel Rijkhof
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!
March 10, 2023

@Tanguy Crusson 
I've created both a new select and a new multi-select field but failed to find a way to configure specific values...

I can only find the way of selecting 0 to 5 *stars.

Please enlighten me 😇


*more like dots...

Jan-Hendrik Spieth
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.
March 13, 2023

@Daniel Rijkhofare you looking for this?

Screenshot 2023-03-13 083558.png

Like Tanguy Crusson likes this
Daniel Rijkhof
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!
March 13, 2023

Thanks @Jan-Hendrik Spieth . That is what i was looking for. Somehow i missed it...

Like Jan-Hendrik Spieth likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events