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):
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 )
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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We'd appreciate a power function, as well. Currently, we're multiplying a lot ... ({effort}*{effort}*{effort} ... ;-))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To do cool stuff we just need that.
Here some examples that are doable with a ^:
1-((1-{__ranged_0to1})^<low_end_boost>)
{__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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm very much open to discuss this topic with you! How can we set it up?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Daniel Rijkhofare you looking for this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks @Jan-Hendrik Spieth . That is what i was looking for. Somehow i missed it...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.