SAP Knowledge Base Article - Public

3288109 - Bold lines and the area underneath them are different colors in a Stacked Area Chart in SAP Analytics Cloud (SAC)

Symptom

When a color axis is ungrouped, the bolded line and the area underneath may show up in different colors in a Stacked Area chart

In the example below, the second trellis has a blue line, but an orange area underneath.

trellis.png

Environment

  • SAP Analytics Cloud (Enterprise) 2023.03

Reproducing the Issue

  1. Create a new Stacked Area chart
  2. Add bindings for Account, Dimension, Color dimension and Trellis dimension
  3. Make sure that Color Axis is ungrouped
  4. Note that some of the stacks might have different colors for the bolded line and the area underneath

Cause

This behavior is by design.  Ungrouping a color axis inserts nulls into the data where specific combinations of color dimension categories and trellis dimension categories do not have any data points. However, nulls are treated as zeros in the stacked area resulting in a line plotted i.e. an area with height zero.

Resolution

If you want the color to be consistent, then check "Unbooked Data" under any of the dimensions added from the builder panel since it will skip the nulls.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0