Calculated fields use cases

The following page contains use cases for the JWT calculated fields. The number of use cases will grow over time, so make sure to visit this page once in a while.

Calculated date-time fields

Use case	Field type	Parser functions	Label
Creation date of the linked epic	Date-time	first() fieldValue() linkedIssues()	STAFF PICK
Predicted completion date of an epic	Date-time	addTimeSkippingWeekends()	STAFF PICK
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()

Calculated number fields

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

Calculated text fields

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

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

Content

Space Tools

Calculated date-time fields

Calculated number fields

Calculated text fields