sisense.com
✅ You are viewing documentation for the latest version of Compose SDK.
Version:

Function pastMonth

pastMonth(measure, name?): CalculatedMeasure

Creates a calculated measure that calculates the value for the same day or week in the previous month.

The time resolution is determined by the minimum date level of the date dimension in the query that uses the returned measure.

Parameters

ParameterTypeDescription
measureMeasureMeasure to apply past value to
name?stringName for the new measure

Returns

CalculatedMeasure

A calculated measure instance

Example

Calculate total cost for the corresponding day or week one month ago from the Sample Ecommerce data model.

measureFactory.pastMonth(measureFactory.sum(DM.Commerce.Cost))
Last Updated: