Add and Modify Variances in Charts

Add a variance to your SAP Analytics Cloud chart to show the difference between versions of an account or to show the difference between time periods.

You can create variances that include either versions or time intervals, or both. You can create a variance for any two accounts, even if they don't appear in your base chart. However, date dimensions must be in your chart if you want to use them in a variance.

How to Add a Variance to a Chart

  1. Select your chart, open the Right Side Panel, and then select Builder.

  2. In the Variance area, select Add Variance.

  3. For both sections (COMPARE and TO), choose specific accounts or choose All Accounts in Use (Dynamic).

  4. (Waterfall charts) Choose the versions.

    1. In the COMPARE section, select Add Version, and then select a version.

    2. In the TO section, select a corresponding version.

  5. (Other chart types) Choose the versions or time periods. (Optional)

    1. In the COMPARE section, select Add Version/Time, and then select a version or time period.

    2. In the TO section, select a corresponding version or time period.

  6. From the Display Options area, apply the following options:

    • Name: use the default name or provide a different name for the variance.

    • Show Variance as:
      • Bar – displays a classic variance chart beside the regular chart.

      • Data Label – adds variance information to the data labels.

        Use data labels if there's no room to add a variance chart, or if you want variance information for charts that can't use a variance chart.

      • Integrated – displays the variance data as an overlay on the bar chart.

      • Waterfall – displays the variance as a waterfall chart for a bar/column chart or a horizontal waterfall chart.

    • Show Difference as:
      • Both – you can still set the number of decimal places for each option.

      • Number

      • Percentage – you can also choose to use an Absolute Base Value.

        Absolute values are useful if you're comparing negative values, but have a positive change (For example, (-20) - (-40) = +20. The percentage change (+20/-40) would be -50% if you didn't use absolute values.)

    • Percentage Point Unit: enter a custom percentage point unit to replace the unit used for percentage vs. percentage variances that is displayed as a number. For example, you can enter a custom percentage point unit as %p, %pt, p.p., or pp.

    • General Display Options:
      • Scale with Base Chart – default setting keeps the variance chart scale the same as the chart scale.

        If you want the variance to have its own scale, clear the checkbox.

      • Invert Colors – reverse the color scheme from the following default values: a positive variance is shown in green, and a negative variance is shown in red.

      • No Data as Zero – to include a NULL data point in your variance, set it to the value zero.

      • Show Integrated Label with Base Label – puts the integrated variance label below the base label, for both positive and negative labels.

        When this option isn't selected, negative integrated variance labels appear.

    • For the Variance Color option, you can customize the color of the following values:
      • Positive

      • Negative

      • Null / 0

    • When finished, select Done.

A variance chart or variance information is added to your visualization.

How to Sort and Rank Variances in a Chart

You can sort or rank either absolute or percentage variances in your charts.

How to Sort Variances

  1. On a canvas page, select a chart.

  2. From the action menu ( ) select Sort.

  3. Select the variance that you want to sort and then choose one of the following options:

    • Lowest to Highest

    • Highest to Lowest

How to Rank Variances

  1. On a canvas page, select a chart.

  2. From the action menu ( ) select Start of the navigation pathRank Next navigation step Top N OptionsEnd of the navigation path.

  3. In the Top N Options dialog, select the dimensions, ranking mode, and number of options (Value).

  4. In the Account section, select the absolute or percentage variance.

    Select Apply.

Variance Bar Colors

The variance bars are color-coded based on the account type and whether an increase is desirable or not. For example, an increase in income would be welcome (green), but an increase in expenses would not (red).

Variance Bar Color Based on Account Type

Account Type

Decrease (-)

Increase (+)

INC – Income

Red

Green

EXP – Expense

Green

Red

AST – Assets

Red

Green

LEQ – Liabilities & Equities

Green

Red

How to Change the Variance Format

After you've added your variances, you can change how they are formatted and displayed in the chart.

  1. Select your chart and open the Builder panel.

  2. In the Variance area, find the variance calculation and select Edit.

  3. In the Edit Variance panel, make your changes.

  4. When finished, select Done.