Tech review

Style guide



Field typeJWT calculated date-time fields
Use case descriptionCalculate the predicted completion date of an epic based on the remaining estimate of all issues in an epic.
Complexity




On this page



Use case

The prediction of the completion date of an epic is very useful for reporting and planning purposes. 

This use case calculates the predicted completion date based on cumulated remaining estimates of all issues linked to each epic.

To calculate the remaining estimates a second calculated field will be used, which is explained in this use case: Total remaining estimate in an epic

Configuration


Create a new Calculated Date-Time Field (by JWT) custom field and name it appropriately.

Providing a description will help you to identify what the custom field does, but this step is optional.



Parser expression

Add the following expression:

addTimeSkippingWeekends(%{system.currentDateTime}, {issue.cf10200}*{DAY}, LOCAL, {FRIDAY}, {SATURDAY})


{issue.10200} is the field code for the calculated field Epic Remaining. See this use case on how to calculate this value: Total remaining estimate in an epic

Additionally to the JWT calculated number field this example uses the addTimeSkippingWeekends() function.




Display Format

Click on Edit Display Format to configure the display format


Choose Date Time Picker as Format type




Add the field to the relevant view screens.


Remember: All calculated fields are read-only and cannot be manually updated on a create or edit screen.



Check the results.

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




 Related use cases