JWT calculated fields | Decadis App Help Center

JWT ships with three custom field types to calculate field values, display live data, or even pull data from online service providers such as Google.

Each custom field type, from number to text, or date-time fields, comes with a different set of options that let you define exactly what you want to see as a result using the full power of the JWT expression editor.

Last but not least, you can individually define how the result of the calculation should appear, from different time formats to currency symbols, by configuring individual Display formats.

Interested in configuring calculated fields? Find detailed information here.

Field types

🗓️ Calculated date-time fields

This type of read-only custom field contains a value which is dynamically calculated from a custom math/time expression. It can be used to obtain a date-time value depending on the value of the current issue or in other issues.

🔢 Calculated number fields:

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 the current issue or in any other issues.

🔤 Calculated text fields

This type of read-only custom field has a value which is dynamically calculated from a custom text expression. It can be used to show a text composed from one or more field values returned by field codes.

📚 Calculated fields library

• Date-time fields

Use case	Field type	Parser functions
Predicted resolution date based on business hours	Date-time	addTime()
Set the calculated field's visibility in function of the username, role or group	Date-time Number Text	isInRole() isInGroup()
Predicted completion date of an epic	Date-time	addTimeSkippingWeekends()
Creation date of the linked epic	Date-time	first() fieldValue() linkedIssues()

• Number fields

Use case	Field type	Parser functions
Number of unresolved blocking issues	Number	count() filterByResolution() linkedIssues()
Number of times a custom field has been changed	Number	count() fieldChangeTimes()
Sum of field value from issues in JQL query	Number	sum() fieldValue() issuesFromJQL()
Total remaining estimate in an epic (no sub-tasks)	Number	sum() fieldValue() issuesUnderEpic()
Total time logged on an epic	Number	sum() fieldValue() issuesUnderEpic()
Difference between the current date and the earliest due date	Number	min() fieldValue() subtasks()
Total remaining estimate in an epic (all linked issues)	Number	sum() fieldValue() issuesUnderEpic() subtasks()
Number of issues in the same version	Number	count() issuesFromJQL()
Months elapsed	Number	month()
Time left before the issue is due	Number	max()
Sum of Tempo billable hours	Number	executeRemoteAction() toNumberList() sum() toNumber()
Number of times a resolved issue has been rejected	Number	count() timesOfTransition()
Number of hours in the current priority	Number	timeInValue()
Number of open subtasks	Number	count() filterByPredicate() subtasks()
Total of all story points in an epic	Number	sum() fieldValue() issuesUnderEpic()
Number of days an issue was in the Open status against a JWT calendar	Number	timeInStatus()
Operate with field values from sub-tasks	Number
Elapsed time between creation and resolution	Number
Highest value out of several fields	Text	max()

• Text fields

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