Function pastQuarter
pastQuarter(
measure,name?):CalculatedMeasure
Creates a calculated measure that calculates the value for the same day, week, or month in the previous quarter.
The time resolution is determined by the minimum date level of the date dimension in the query that uses the returned measure.
Parameters
| Parameter | Type | Description |
|---|---|---|
measure | Measure | Measure to apply past value to |
name? | string | Name for the new measure |
Returns
A calculated measure instance
Example
Calculate total cost for the corresponding day, week, or month one quarter ago from the Sample Ecommerce data model.
measureFactory.pastQuarter(measureFactory.sum(DM.Commerce.Cost))