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?

[Bill Sheboy]

Hi @Tom Haapanen 

Filtering by a vote field is not possible yet.  Please see this other question for some work-arounds: https://community.atlassian.com/t5/Jira-Product-Discovery/Filter-by-votes/m-p/2386546

Kind regards,
Bill

[Tom Haapanen]

Thanks @Bill Sheboy . 

[Nick Haller]

Hi @Tom Haapanen ,

As already mentioned, it's not possible to filter by votes at this time. We'll get some sort of feature request entered with engineering.

But you can at least sort this field in ascending or descending order - so hopefully that somewhat helps:

[Ivan Ferreira]

Hello Tom. I haven't tested myself, but I think that William Sheboy answer here is interesting.

How about a work-around?

• Add a custom Number field: Last Vote Count
• Add an automation rule to...
• Trigger on issue edit
• Check condition of issue.voters.size does not equal the custom field, Last Vote Count
• Then do your actions, and update the Last Vote Count

Maybe with a little tweak of this automation, or a formula field based on votes, you can change a custom field that can classify ideas by some range of vote count. Use this classification as the grouping field in a view.

[Tom Haapanen]

It's good as far as workarounds go. Hope to see some improvement from Atlassian to remove the need to resort to workarounds.