Symptom
Bar Charts with % Percent-based measure are not showing complete labels on the Y-axis. Labels per Data values are shown on top of or beside each bar but the informational or reference labels along the axis are not shown or are incomplete (e.g. only 0% is shown and not the ranges 0%, 50 % 100%)
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
- SAP SuccessFactors People Analytics
- Stories in People Analytics
Reproducing the Issue
1. Create a Story and add a bar chart
2. Set a Percent-based field or column (could be standard or calculated columns) as Measure
3. Observe the Chart visual that is generated. Notice that along the Y-axis, the percent labels or reference points are not displayed. See below for reference:
Chart with Issue:
Chart that is showing more axis labels:
Cause
It is expected that charts would intelligently build the axis scale based on the data values. In the example chart, the data values not more than 20% (the largest percent is 18.05%) . If the Y-axis is built with 0% to 100% - the bars will be very less in height causing comparison difficult. And, if we show 0%-20% (since first highest round digit number for the given values is 20%), then the representation of data will be misleading. As per chart guidelines (Hi-chart representation), the graph should not show % scale like that (0%-20%).
For other charts, there are values that reach beyond 100% e.g. 111% hence the scale of 0-100% is shown.
Resolution
The axis scales vary based on data values. The focus will be more on how to make the data points readable and allow clear comparison to bring insights. The axis scale should be dynamic i.e. there are no fixed 0%- 100% access labels. This is working as designed.
See Also
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/5bb8a7d18a3c479897fc64bc0820364a.html?q=chart+label#problem%253A-chart-does-not-display-all-of-the-expected-data-labels
Problem: Chart does not display all of the expected data labels
"When designing a chart, some of the labels may not appear when the chart is displayed.
The default setting for labels in charts is that when they overlap or collide with one another, or can't fit within the allotted space, they should be hidden."
Keywords
chart labels, y-axis, percent based measures, data labels, , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To
Product
Attachments
Pasted image.png |
Pasted image.png |
Pasted image.png |
Pasted image.png |