Widgets - How to Group Items in a Widget by Status Meaning?

Tags: widgets

IMPORTANT! The information on this page is unverified and unsupported. Always double-check the accuracy of the solutions provided. Evaluate and test the impact on any environments!

Description

Currently, in Reports, it is possible to group items by status Name:

[!groupItemsByStatusName.png#0ce6d52366bd4851448a17b77c592c34!]

And then, display them through a Charts widget:

[!displayItemsChartWidget.png#6abd42af7fb6a0df561c2cfbf1ac672b!]

Is there a way to display or group items by status Meaning instead?

[!statusMeaning.png#b60f14301b5aef6647a46ce073dd005e!]

Observed on

codebeamer 21.09-LTS (EMMA)

Solution

Out of the box, Reports support the selection of Meaning:

[!reportsSectionMeaning.png#6af166c7a7a10594b344577592371af3!]

However, currently, this is not implemented in Widgets.

As an alternative, you may create a calculated field (full guide at Calculated Issue Fields) into the tracker and use it as a grouping field in a report/widget.

In the below example, just like in a ternary operator, the formula prints Finished for items with status Done or Implemented, else, it prints In Work:

valueInList(status.name, "Done", "Completed") ? "Finished" : "In Work"

This can be added as a Report grouping field:

[!reportGroupingField.png#c864ba8aa9bcbda7bcbd41d2ed33d3d4!]

and then, in a Charts widget:

[!chartsWidget.png#3f3a9dd14227af9871414b17c8b8077d!]

For any other Support options, questions, or inputs, visit: https://intland.com/technical-support/

Widgets - How to Group Items in a Widget by Status Meaning?

Table of Contents

Description

Observed on

Solution