Customize the "Resolved" field column format using the "Calculated fields" feature

When designing a new report, a customer might be required to use a column format that is not part of the available options for the Resolved field. In this case, configuring a Calculated field can be a solution.

Open

 Instructions

• In Reports and Timesheets, you can use the Expression Builder to create a Calculated field. Refer to the configuration and captures below:

  • Use the CONCAT() function

  • Value 1: “Week of” or any other string (prefix) the customer might require

  • Value2:

    • Add the TOSTRING() function

    • Value: FORMAT DATE() function

      • Date: “Resolved” Jira field value

      • Pattern: dd/MM or any other date formatting pattern

Open

• Output:

Open

 Related articles