How to display custom date field where the status is done with certain fix versions

Owned by Kinnera
Last updated: Jun 30, 2021 by Amith Mathur
2 min read

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.



  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.


  13. Drag the Format Date function in the value 1,  Custom date field in the date and the pattern as shown below:


  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: