Use cases for calculated fields

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	JWT feature	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	(input latin letters)	Date-time Number Text	isInRole() isInGroup()

🔢 Calculated number fields

Use case	JWT feature	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	(input latin letters)	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()

(input latin letters) Calculated text fields

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