Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 24 Next »

On this page

This type of read-only custom field has a value which is dynamically calculated from a custom math/numeric expression. It can be used to obtain a numeric value depending on the value of other fields in current issue or in any other issues (linked issues, sub-tasks, epics, stories, JQL selected issues, etc).

Configuration

Math expression

This parameter contains a valid math expression that will be calculated each time the value of the field is required.

Example 1 : Calculated Number Field "Number of Blocking Issues"

In this step by step example we show how to create a calculated number field called "Number of Blocking Issues" that will return the number of unresolved issues, the current issue is linked to "is blocked by" issue link type.

Create a new Calculated Date-Time Field custom field and name it properly.

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

Parser expression

Add the following expression:

Math expression for Calculated number field:
count(filterByResolution(linkedIssues("is blocked by"), ""))

To achieve this, the following functions are used:

Finally, the configuration of the new custom field should look like this:

Example 2: Calculated Number Field "Time to Due Date"

In this example we configure a calculated number field that will show the remaining time for Due Date.

Create a new Calculated Date-Time Field custom field and name it properly.

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

Parser expression

Add the following expression:

Math expression for Calculated number field:
{00012} != null ? max({00012} - {00057}, 0) : null

{00012}  is code for Due date, and {00057} is code for Current date and time.

To achieve this, the following functions are used:

  • Conditional operator ?:
  • max() is used to avoid returning a negative duration when the Due date has passed.

Display format

Choose Duration for Content type

Choose Short for Duration display format

We select duration as display format, since the numeric value being calculated, a number of milliseconds, represents a time duration. This way the value is represented like Time to Due Date: 2d 9h 43m instead of a single number.

Check the parameter Uninitialized when calculated value is zero

Since we don't want the field to be shown once Due Date has been reached.

Finally, the configuration of the new custom field should look like this:

Example 3: Field to show time since issue creation resolution

In this example we configure a calculated number field for showing the time elapsed since issue creation to issue resolution. For issues which are still not resolved, the field will be uninitialized, thus it won't be shown in the view screen.

Create a new Calculated Date-Time Field custom field and name it properly.

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

Parser expression

Add the following parser expression:

Math expression for Calculated number field:
{00112} != null ? {00112} - {00009} : null

{00112} is code for Date and time of resolution, and {00009} is code for Date and time of creation.

To achieve this the following functions are used:

  • Conditional operator ?:

Display format

Choose Duration for Content type

Choose Long for Duration display format

Check the parameter Use time tracking settings

We get the duration displayed using the number of working hours per day, and the number of working days per week as configured in time tracking, instead of 24 hours per day and 7 days per week.

Finally, the configuration of the new custom field should look like this:

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