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.4


Section


Column
width600px


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

Table of Contents
maxLevel

1

2



Column




Features used to implement the example



Example:

Calculating

Total remaining

time in issues and subtasks of epics

estimate in an epic

Sum up the remaining estimates In this example we want to calculate and display the remaining time (in days) of issues and subtasks in an epic.

For this we need a calculated number field. 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

The display format configuration is shown in the following screenshot.

Image Removed

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.


Note that:

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


In order to return days, the display format is configured as shown:

Image Added


Once configured and added to an issue screen (e.g. an epic), the result Adding the second custom field to the epic 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"