Issue
When building a chart on a report, or in a dashboard, you are limited to the Grouping values or names, which usually include 'Sum' or 'Avg' etc. within the chart axis Label (see below).
Resolution Steps
- As a workaround, create a custom Report Formula that pulls in the same data as the grouping you'd like to display in the chart.
- Custom report formulas can have any Name you choose.
Using the example above, say we want the highlighted text to just say 'Rating', as 'Sum of Rating' is misleading, since it is only 'Summing' the total of 1 rating per data point.
Creating a report formula, we can name it 'Rating', but the formula itself is still giving us the 'Sum':
Save your Formula
In the Chart Editor, select the new Formula as the Y-Axis:
Save and Run your Report to see the Axis Name change:
See also: https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000A7SixSAF