Displaying the Compound Annual Growth Rate for a Chart

Show the Compound Annual Growth Rate for SAP Analytics Cloud Bar/Column or Stacked charts.

Prerequisites

The chart must meet the following requirements:

  • The chart must have a Date dimension on an axis.

  • The time period that is used must be higher than week (for example, month, quarter, or year).

  • There need to be at least two positive data points in the selected time period.

Note

This feature is not yet available for SAP BW Live models.

Context

The Compound Annual Growth Rate (CAGR) is the ratio that provides a constant rate of return over the time period. You can add a CAGR line to your Bar/Column or Stacked Bar/Column chart.

Procedure

  1. Select your chart.
  2. From the chart action menu (), select Start of the navigation pathAdd Next navigation step CGREnd of the navigation path.

Results

A CAGR line is added to your chart. If you have changed the drill level for other dimensions, you may see separate CAGR lines instead of a continuous one.