Page Comparison

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:

1. Navigate to Jira Menu → AIO Reports → My Area → My Calculated Fields.
2. Click Create New Field to create a new calculated field.
3. From the right-hand side, search for the function IF ELSE and drag the function to build the expression.
4. Likewise, drag the function IN  and place it in the condition.
5. Now drag the Fix Version Name field to the value.
6. Within the listItem1, click on Enter a constant value and input the Fix Version Name.
7. Click Add parameter to add listItem2 and enter the value. 
8. Repeat the above step if there are more than 2 Fix version names to be included.
   Image Removed
   Image Added
   
   
9. Now drag the function IF ELSE into value 1 to validate the Current Status field
10. Likewise, drag the function EQUALS  and place it in the condition.
11. Drag the Current Status field to the value 1.
12. Click Enter a constant value and input Current Status name as Done.
    Image RemovedImage Added
    
    
13. Drag the Format Date function in the value 1,  Custom date field in the date and the pattern as shown below:
    Image RemovedImage Added
    
    
14. Enter the values for value2 as NA and name the calculated field along with the description.
15. Validate the expression, save it and use the field in the reports:
    
    The results are as shown below:
    Image RemovedImage Added