This article helps in the creation of a calculated field that filters the results for the date custom field based on the status and fix-version fields.
Instructions
Consider the conditions as Status = Done and Fix version is in release-1, release-2, release-3, and the custom field here is Custom date:
- Navigate to Jira Menu → AIO Reports → My Area → My Calculated Fields.
- Click Create New Field to create a new calculated field.
- From the right-hand side, search for the function IF ELSE and drag the function to build the expression.
- Likewise, drag the function IN and place it in the condition.
- Now drag the Fix Version Name field to the value.
- Within the listItem1, click enter a constant value and input the Fix Version Name
- Click Add parameter to add listItem2 and enter the value.
- Repeat the above step if there are more than 2 Fix version names to be included
- Now drag the function IF ELSE into value 1 to validate the Current Status field
- Likewise, drag the function EQUALS and place it in the condition.
- Drag the Current Status field to the value 1.
- Click Enter a constant value and input the Current Status name as Done.
- Drag the Format Date function in the value 1, Custom date field in the date and the pattern as shown below
- Enter the values for value2 as NA and name the calculated field along with the description.
- Validate the expression, save it and use the field in the reports.
The results are as shown below: