SAP Knowledge Base Article - Public

3493041 - Chart display wrong value when enable zero suppression in SAP Analytics Cloud(SAC)

Symptom

  • When enable zero suppression, then the chart display wrong value. It seems the values of two columns exchanged. 
  • The data source is SAP Datasphere.

Environment

SAP Analytics Cloud(SAC) 2024.8.16

Reproducing the Issue

  1. Login SAC and create a new story.
  2. Add a bar chart
  3. Add two measures: Budget amount, Actual amount.
  4. Add month as dimension.
  5. Add year dimension for color.
  6. Take Jan as an example, the bar values now are as below:
    2024/Budget amount: 90000
    2024/Actual amount: 150000
  7. Enable Zero Suppression
  8. Notice that the values exchanged:
    2024/Budget amount:150000
    2024/Actual amount:90000
  9. In har file-preview, notice the values are still same as that in step6:
    2024/Budget amount: 90000
    2024/Actual amount: 150000

Cause

This issue has been fixed by development.

Resolution

This issue has been fixed by development.

See Also

Keywords

chart, zero suppression, wrong value, chart display, bar chart, add dimension for color, color , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-DES-NLQ , SAC Story Natural Language Query, suggestions , Problem

Product

SAP Analytics Cloud 1.0