Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

calculate value of customfield based on custom fields of other issues

Hen Aen I'm New Here Nov 23, 2020

Hi Community,

In our JIRA project we would like to create a calculated customfield to prioritize issues and need your input for the realization.
Here is the situation:
We have issuetype A and issuetype B. Issuetype B has a customfield B1, which indicates the priority of the issue in form of a number. Via customfield A1 of issuetype A, one or more issuetype B are assigned to issuetype A (e.g. via multiselect/multilink).
What we are now looking for is a customfield A2, which returns the largest value of a customfield B1 of all issuetypes B assigned with the issue A.

In simple terms, the customfield A2 should calculate the following:
"return the maximum value of all customfield B1 of all issues specified in A1"

Do you have an idea how this can be realized? Which JIRA Addons are necessary for this?

Thanks in advance!

1 answer

0 votes
Guilhem Dupuy Community Leader Nov 23, 2020

Hello,

Unfortunately, I don't know anyway to return the maximal value of a field.

However, it is a bit longer but you can use an "If/Else" loop checking the different values of the B1 field (using a request of the type "If one of B1 field = XX")

By stating with the highest values available for B1 and then going down in your next IF/Else iterations, you should obtain the desired result. It's fastidious, but it works :) 

 

Let me know if it helped,

Guilhem

Hen Aen I'm New Here Nov 24, 2020

Hi!

Thanks for your answer! That seems like a good workaround for the lack of a "max"-function. Unfortunately I cannot test this by now.

Assuming we would find a way for the Max function, do you know if it is possible to configure a customfield A2 to return the value of another customfield B1 from other issues listed in A1?

Thanks!

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you