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 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

...

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
showSpacefalse
sortmodified
showSpacetypefalsepage
reversetruetypepage
labelskb-how-to-article
cqllabel = "kb-how-to-article" and type = "page" and space = "SUPPORT"