Versions Compared

Key

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

This article helps in the creation of a concatenated calculated field based on two string fields and how to use that field in the reports. 

Instructions

In this article, we are considering Status and Issue type fields as an example:

  1. Navigate to Jira Menu → AIO Reports → My Area → My Calculated Fields.
  2. Click Create New Field to create a new calculated field.
    Image Removed
    Image Added

  3. From the right-hand side, search for the function CONCAT and drag the function to build the expression.
    Image RemovedImage Added

  4. Now drag the Current Status field to value1.
    Image Removed
    Image Added

  5. For value2 click enter "Enter a constant value" and input the separator as '-'.
    Image Removed
    Image Added

  6. Click Add parameter and drag the Issue type field to value 3 as shown below.
    Image Removed
    Image Added

  7. Name the Calculated field, describe it Enter a Description for future reference and add it to an existing or new category (optional).
  8. Validate the calculated field before saving it and then saveClick on Save:
    Image RemovedImage Added

  9. Navigate to new report or existing reports, add this field to the report along with the count of issues field to see the issue count against the calculated field as shown below:
    Image Removed
    Image Added
  10. Click on any of the counts of issues number to see the actual results:
    Image RemovedImage Added