Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

Versions Compared

Old Version 16

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Complexity

Page properties
hiddentrue


Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

Page status

Status
colourGreen
titlecomplete

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged

Calculated field typedate-time
Use case description



UI Text Box
sizemedium
typeinfo

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 (all linked issues)


Image AddedConfiguration

Configuration

UI Text Box
typetip
Check JWT calculated date-time fields to learn the steps on how to add a calculated date-time field.

UI Steps


UI Step

Create a new Calculated Date-Time Field custom field called "Predicted due date of an epic"(by JWT) custom field and name it appropriately.

UI Text Box
typetip

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



UI Step

Parser expression

Add the following expression:

Code Block
languagebash
titleDate/Time expression for Calculated Date/Time field:
linenumberstrue
addTimeSkippingWeekends(%{00057system.currentDateTime}, {10200issue.cf10200}*{DAY}, LOCAL, {FRIDAY}, {SATURDAY})


ui-expand
titlemore info...


UI Text Box
typeinfo

{issue.cf10200

  • {00057} is the field code for Current date and time
    • {10200

    } is the field code for

    custom field Epic Remaining

    the calculated field Epic Remaining. See this use case on how to calculate this value: Total remaining estimate in an epic (all linked issues)

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




    UI Step


    UI Steps

    Display Format

    UI Step

    Click on Edit Display Format to configure the display format

    UI Step

    Choose Date Time Picker for Format type

    Format type

    Choose Date Time Picker




    UI Step

    Add the field to the relevant view screens.

    UI Text Box
    typenote

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



    ui-step
    UI Step

    Check the results

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




    Image Added Related use cases

    Page properties report
    headingsField type, JWT feature, Label
    sortByTitle
    cqllabel = "calculated-field" and space = "JWTSDC" and ancestor = "27068727"

    Excerpt Include
    DECADIS:Contact support
    DECADIS:Contact support
    nopaneltrue


    Page properties
    hiddentrue


    JWT feature

    Image Added

    Field typeDate-time
    Parser functionsaddTimeSkippingWeekends()
    Label

    Status
    colourRed
    titlestaff pick