Comparisons

The comparison methods available for analyzing how data changes: absolute comparisons, relative comparisons (default and simple), and CAGR.

Absolute comparisons

Absolute comparisons simply calculate the delta between the data points.

Relative comparison - default

The relative comparison is calculated as:

| (Avalue / first value) -1 | * signum(second value - first value)

or in simple words: “The relative percentage change with the sign of the absolute change.”

Relative comparison - simple

The simple comparison calculates the percentage difference as:

(second value / first value) -1

The drawback of this comparison scheme is, that it produces negative values on a negative base. Although the change is usually “positive” - at least from a business perspective. Use the default relative comparison to circumvent this problem.

CAGR - cumulated average growth rate

Calculates the average growth necessary over the given years to reach the second value.