SAP Knowledge Base Article - Public

3043020 - How to change variance data label values to percentage in waterfall chart in SAP Analytics Cloud (SAC)

Symptom

  • In waterfall chart not found an option to change variance data label values to be percentages.
  • It should be possible to display the "variances" shown in the waterfall chart also as separate variance in %. 

Environment

SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Login to SAC.
  2. Create a new story e.g. based on a sample model "BestRunJiuce_SampleModel".
  3. Insert a chart: Insert - Chart
  4. Select Chart Structure - Comparison - Waterfall
  5. Select Chart Orientation - Vertical
  6. Add a Measures e.g. [Gross Margin] and Dimensions [Date]
  7. Add Filter [Date (Member)]:
    • select years "2015" and "2016",
    • change Show Hierarchy to "Year, Month"
  8. Now follow instruction per Drilling through Waterfall Charts and drill for Month for both years in the chart.
  9. Edit data labels: Designer - Styling -  click on the data labels in the chart => No option to change the data label variance values to percentage.

Cause

This is a limitation in the product.

Resolution

Note:

    • The variance chart is based on all the measures in the Waterfall chart.
    • Set up your chart with one measure and a Date filter.
    • The Date filter must have only one value.
    • Time based variance is only supported for waterfall chart when there is no dimension and not more than one version used in the chart.

This document and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.
This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement.

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0