Highest ranked custom field value among all linked issues

Use case

This calculated field returns the highest value of a specific custom field among all linked issues.

In this example, the Story Points are returned. The Story points are stored in another custom field called Story Points.


⚒️ Configuration

Create a new Calculated Text Field (by JWT) custom field and name it properly.

Providing a description will help you to identify what the custom field does but this step is optional

Parsing mode

Select Advanced text as parsing mode.

Parser expression

Add the following expression:

Bash
first(sort(fieldValue(%{issue.cf10409}, linkedIssues()),DESC))

%{issue.cf10409} is the field code for the custom field Story Points.

To achieve this, the following functions are used:

Add the field to the relevant view screens.

Remember: All calculated fields are read-only and cannot be manually updated on a create or edit screen.

Check the results

Once configured and added to an issue screen, the result will look like this:

HighestRankedCustomFieldValueAmongAllLinkedIssues1.png

HighestRankedCustomFieldValueAmongAllLinkedIssues2.png


📚 Related use cases