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

Function pastWeek

pastWeek(measure, name?): CalculatedMeasure

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

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 one week ago from the Sample Ecommerce data model.

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