Comparisons
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.