Display the highest value out of several fields

Use case

Display the highest value out of several fields.

This use case can be useful to evaluate the prioritization of an issue if the parameters are written in the format number - degree, as in 1 - Low, 2 - Medium, 3 - High.

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

Set the Parsing Mode to Advanced text

Parser expression

Add the following expression after replacing the field codes for the corresponding ones.

last(sort([%{issue.cf10001}, %{issue.cf20002}, %{issue.cf30003}, %{issue.cf40004}, %{issue.cf50005}], ASC))

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.

Related use cases

Use case	Parser functions	Label
Check if an issue was resolved on time	datePart()
Components from all sub-tasks	toString() distinct() fieldValue() subtasks()
Details of the last comment		STAFF PICK
Difference between two dates in business days	formatWorkDuration() timeDifference()
Display additional details of the issue creator
Display current issue's project category
Display historic due dates	toString() textOnNumberList() fieldHistory() dateToString()
Display reporters of linked Cloud issues	executeRemoteAction() findPattern() toStringList() toString() distinct()
Google Maps location	replaceAll() toLowerCase()	STAFF PICK
Highest ranked custom field value among all linked issues	first() sort() fieldValue() linkedIssues()
Last comment, its author, and timestamp	userFullName() dateToString() last() allCommentDates()	STAFF PICK
Last commenter's full name	userFullName()
Status and assignee of parent issue

If you still have questions, feel free to refer to our support team.

Content

Space Tools

On this page

Use case

Configuration

Parser expression

Related use cases