Adding Time-Based Variances to Charts

Add a time dimension to your SAP Analytics Cloud chart to see some recommendations for comparisons (variances) that you can also add.

When you create a chart and add a time or date dimension to it, some recommended comparisons are listed in the Builder panel above the Measures list. Select one or more of the comparisons to add them to your chart. The first comparison is applied as a data label and the rest of the comparisons are listed as Variances at the top of the chart.

Only one variance can be added as a data label, but you can select a datapoint to see all the variances in the tooltip.

How to Choose a Time Comparison

You can choose to add a variance or comparison from the chart or from the builder panel.

Tip
The available comparison options are dependent on your time hierarchy: the more granular the hierarchy, the more options that will be available, including one or more of the following options:
  • Previous Period
  • Previous Year
  • Previous Half Year
  • Previous Quarter
  • Previous Month
  • Previous Week
  • From the chart: select the chart, or select a data point in the chart, and then either right-click or select (More Actions) and then select Compare To and choose a comparison option.

  • From the Builder panel: select a chart and then in the Builder panel choose a comparison from the Recommended Comparisons section.

    Note

    Recommended Comparisons won't be available if your time dimension uses week-level granularity or the dimension is a user-managed time dimension.