Function growthPastQuarter

growthPastQuarter(measure, name?): CalculatedMeasure

Creates a calculated measure that calculates the growth from the previous quarter to the current quarter.

The date dimension will be dynamically taken from the query that uses the returned measure.

Growth is calculated using the following formula: (currentQuarter – previousQuarter) / previousQuarter.

For example, if this quarter the value is 12 and the previous quarter's value was 10, the growth for this quarter is 20%, returned as '0.2' (calculation: (12 – 10) / 10 = 0.2).

If the previous quarter's value is greater than the current quarter, the growth will be negative.

For example, if this quarter the value is 80, and the previous quarter's was 100, the growth for this quarter is -20%, returned as -0.2 (calculation: (80 – 100) / 100 = -0.2).

Parameters

Parameter	Type	Description
measure	Measure	Measure to apply growth to
name?	string	Name for the new measure

Returns

CalculatedMeasure

A calculated measure instance

Example

Calculate the growth in total cost this quarter in comparison to the previous quarter from the Sample Ecommerce data model.

measureFactory.growthPastQuarter(measureFactory.sum(DM.Commerce.Cost))