Skip to end of banner
Go to start of banner

How to concat two fields and use it in reports

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

Consider the 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.
  3. From the right-hand side, search for the function CONCAT and drag the function to build the expression.
  4. Now drag the Current Status field to value 1.
  5. For value 2 click enter a constant value and input the separator as '-'.
  6. Click Add parameter and drag the Issue type field to value 3.
  7. Name the Calculated field, describe it for future reference and add it to an existing or new category(optional).
  8. Validate the calculated field before saving it and then save.

  9. Navigate to new report or existing reports, add this field to the report along with Count of issues field to see the issue count against the calculated field as shown below

  10. Click on any of the count of issues number to see the actual results

     

        


  • No labels