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

0 votes
Rohan Swami
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 5, 2024

Hi @John McDonald we currently only support syncing the Target date from Atlas back to the JPD idea. I've recorded your request to also sync the Start date for our future prioritisation.

Carlos Garcia Navarro
Community Champion
March 5, 2024

I'll let @John McDonald confirm, but I think that he's trying to sync the dates from Atlas to JPD, not the other way around. I'm experiencing the same issue, where the start and target dates in JPD are set to the the target date in JPD. It's not happening consistently though.

Like peter likes this
0 votes
Carlos Garcia Navarro
Community Champion
March 5, 2024

Hi @John McDonald ,

I'm experiencing the same issue. @Nicola Sun mentioned in this post that date syncing is not supported today between JPD and Atlas, but that they're adding this to their backlog.  I'm hoping it can be solved quickly since we rely on this to have accurate dates in both tools.

https://community.atlassian.com/t5/Atlas-questions/Start-and-target-dates-are-not-synchronizing-correctly-between/qaq-p/2610802

Rohan Swami
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 5, 2024

hi @Carlos Garcia Navarro this is a separate issue to what John is raising. The discrepancy between the 2 dates in your Community post is due to a bug where we are using different timezones in JPD and Atlas, we're working on a fix now!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events