Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from this space and version 2.5.3


Section


Column
width600px


Panel
borderColor#333f48
bgColor#FFFFFF
titleColor#eeeeee
borderWidth1
titleBGColor#333f48
borderStylesolid
titleOn this page

Table of Contents
maxLevel12



Column




Features used to implement the example



Example:

Calculating

Total remaining

time in issues and sub-tasks of epics

estimate in an epic

Sum up the remaining estimates In this example the remaining time (in days) of issues and subtasks in an epic will be calculated.

For this a calculated number field is needed. The configuration will look like thisA valid configuration for this Calculated Number Field:

Text to be parsed

is: sum

  • sum(fieldValue({00024}, issuesUnderEpic() UNION linkedIssues("",issuesUnderEpic()))) /480


Note that:

  • {00024} is the field code for field Remaining estiamte Remaining Estimate (in minutes)


The In order to return days, the display format configuration is shown in the following screenshot.configured as shown:

Text to be parsed is: ###.## d

This is done for displaying the remaining time in days.

Adding the custom field to the issue screen will look like this:

Image Removed

Adding a predicted due date to the epic

Resulting of the created custom field, another custom field can be configured to predict a due date for the whole epic based on the Remaining time.

For this a JWT Calculated Date-Time Field is needed.

The configuration will look like this:

Image Removed

Image Removed

Text to be parsed is: addTimeSkippingWeekends({00057}, {10200}*{DAY}, LOCAL, {FRIDAY}, {SATURDAY}) 

Note that:

  • {00057}is field code for field Current date and time
  • {10301} is field code for custom field Epic Remaining. It could distinguish from your custom field code.

Adding the second custom field to the epic Once configured and added to an issue screen (e.g. an epic), the result will look like this:

Image RemovedImage Added




Other examples of this custom field

Incoming Links
pageCalculated Date-time Number Field
labelsexample



Related Usage Examples

Content by Label
showSpacefalse
cqllabel = "example" and label = "calculated-field"