Use case

This calculated field returns the number of days an issue was in the "Open" status considering the configured JWT calendar.

Configuration


Assumption: A custom JWT calendar called "my_calendar" has been defined as follows:
MON - THU {
   08:00 - 15:00,
   16:00 - 19:30;
}
 
FRI {
    08:00 - 15:00;
}

Create a new Calculated Number 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.

Parser expression

Add the following expression:

Math expression for Calculated Number field:
timeInStatus("Open", "my_calendar", LOCAL) / {DAY}
more info...

Apart from a time macro, the following functions are used:

Display format

Content type

Choose Number

Number format pattern

Choose

### days

Check the parameter Uninitialized when calculated value is zero

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 (a parent issue ), the result will look like this:



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