SAP Knowledge Base Article - Public

3472221 - Stacked Bar/Column chart sorting within the category does not show correct order in SAP Analytics Cloud (SAC).

Symptom

Stacked Bar/Column chart shows incorrect data when sorting is applied over it.

Environment

SAP Analytics Cloud.

Reproducing the Issue

  1. Login to SAC tenant.
  2. Open the story.
  3. Add a Stacked Bar/Column chart.
  4. Click on Quick action menu (...)
  5. Apply Sort.

Observe that the bars in the chart are not arranged from highest to lowest or vice-versa.

Cause

This behaviour is by design.

Resolution

Currently, sorting does not work with Stacked Bar/Column chart. Kindly vote here -  https://influence.sap.com/sap/ino/#/idea/280959.

However, it is important to note that the sorting of measures is done based on the totals of the categories, rather than within the categories themselves.

See Also

Keywords

SAP Analytics Cloud, SAC, stacked bar/ column, sorting, measures, chart. , KBA , LOD-ANA-DES-CHART , SAP Analytics Cloud core charting , Problem

Product

SAP Analytics Cloud all versions