Difficulty Grouping Data by "Actual Value" Field in Performance Analytics Pie Chart

[Saraswathi Devi]

Hi,

I'm having trouble grouping data from the asmt_metric_result table in Performance Analytics. I want to create a pie chart that groups by the "actual value" field, but I'm unable to do so. I've followed the instructions in the documentation linked below, but I still can't use the breakdown option as described.

Create a pyramid or a funnel visualization for a breakdown widget (servicenow.com)

Grouping by breakdown and filtering by breakdown (servicenow.com)

Snip from normal report(where we want this as requirement)

But we are getting like below.

Can anyone help me figure out what I might be missing?

[Michael Penafie]

Grouping by 'Scaled Value' got me the output I wanted. Not sure if that helps. Here is what I gathered from further research into the asmt_metric_result table values:

Actual Value
Definition: This is the raw score or data point captured directly from the assessment input.
Purpose: It represents the unmodified, original value as recorded by the user or calculated by the system during the assessment.
Example: If a user rates a question as 8 out of 10, that “8” is the actual value.

Scaled Value
Definition: This value is a normalized version of the Actual Value.
Purpose: Because different metrics might use different ranges or scales, the Scaled Value converts the raw score into a common range (for example, 0–1 or 0–100). This normalization makes it easier to compare and aggregate scores across multiple metrics.
Example: The raw score of 8 out of 10 might be scaled to 0.8 (when using a 0 to 1 scale).