Displaying the Compound Annual Growth Rate for a Chart

Show the Compound Annual Growth Rate for 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.

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.