Versions Compared

Key

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

When designing a new report, a customer might be required to use a column format that’s that is not part of the built-in/ 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 builderBuilder to create a Calculated field. Please refer 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

...

  • Results / outputOutput:

...

Info

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.

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@bc3e0baf
sortmodified
showSpacefalse
reversetrue
typepage
labelskb-how-to-article
cqllabel = "kb-how-to-article" and type = "page" and space = "SUPPORT"