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

Owned by Pablo Vergara, created
Last updated: Apr 05, 2024
2 min read

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.

 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

  • Output:

This example can be expanded to other Jira or custom fields. The pattern will depend on the type of field that is being used by the customer.