Tags: fields Report Wiki-Plugin

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!

Widgets - Can I Order a Report by Choice Field ID?

Description

Having a tracker field of type Choice:
[!D1.png#0ea69cee5fb5c18fc34537f1fbe2616e!]

and possible options, each one having an ID:
[!D2.png#edb40d834556eea1dc19d1beb3591141!]

Is it possible to get a report that is shown in a chart widget, and orders choice fields by their IDs? For example: 1. To Do, 2. In Progress, 3. Implemented..., 8. Verified?

Observed on

Codebeamer - 22.10-LTS (GINA)

Solution

Out of the box, the Chart widget does not ship this functionality.

Workaround:

Implement a computed Text field that pulls the choice ID and the choice name, for example concat(status.id, " - " ,status.name):
On each item, this will output the status.id and status.name:
Having the status.id in a field, all report operations can be performed on it.
For example:
This can be finally shown in a Chart widget: