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

[Daniel Rijkhof]

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?

[Tanguy Crusson · Accepted solution]

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]

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]

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

[Daniel Rijkhof]

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>)

High end boost (high_end_boost: 3)

{__ranged_0to1}^<high_end_boost>

Double boost: (high_end_boost and low_end_boost at 3)

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

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...

[Tanguy Crusson]

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.

[Daniel Rijkhof]

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

[Tanguy Crusson]

@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!

[Daniel Rijkhof]

@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]

@Daniel Rijkhofare you looking for this?

[Daniel Rijkhof]

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