Skip to end of banner
Go to start of banner

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

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

« Previous Version 3 Current »

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.

\uD83D\uDCD8 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.

  • No labels
Error formatting macro: appfire-confluence-analytics: java.lang.NullPointerException: Cannot invoke "com.atlassian.confluence.xhtml.api.MacroDefinition.getMacroId()" because "macroDefinition" is null