Donut widget type displays multiple of the same entries

[fruitcakej]

Description

When creating a dashboard widget of type “Donut”, perspective “Entities” with filters Label and Parameters attribute set to “Status”, multiple entries are displayed.

The intention of this dashboard widget is to display the distribution of statuses for RFIs, Incident Responses and Tasks with the label.

Environment

6.5.1 SaaS

Reproducible Steps

Steps to create the smallest reproducible scenario:

From a dashboard, create a widget
Select the “Donut” Visualisation
Select the “Entities” Perspective
Filter for the labels
Under Parameters > Attribute, select “Status”

Expected Output

Actual Output

Multiple entries for fields are displayed

Screenshots (optional)

(recreated in testing with following labels)

[nino-filigran]

@fruitcakej the reason is because you may have different entity types. Each of them has a status NEW, but this "NEW" status has a different id for each entity type, leading to this situation (it is interpreted as 2 different statuses in the end).
Therefore, this is "normal", but I agree, far from being optimal.

Given that we have fixed this behavior in the filters of the platform (for instance, if you try the same query on data entity, only a single status NEW will be available), we should do the same in the dashboards.