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

Function measureLessThan

measureLessThan( measure, value, config?): Filter

Creates a filter to isolate a measure value less than a given number or date.

Parameters

ParameterTypeDescription
measureBaseMeasure | CalculatedMeasureMeasure to filter by
valueDate | number | stringValue. For a date measure pass a Date or an ISO 8601 string.
A number is only valid for a numeric measure.
config?BaseFilterConfigOptional configuration for the filter

Returns

Filter

A filter instance

Example

Filter for categories that have an average revenue less than 100 in the Sample ECommerce data model.

filterFactory.measureLessThan(
  measureFactory.average(DM.Commerce.Revenue),
  100
)

Example

Filter for categories whose last order was before 1 December 2013 in the Sample ECommerce data model.

filterFactory.measureLessThan(
  measureFactory.max(DM.Commerce.Date.Days),
  new Date('2013-12-01T00:00:00')
)
Last Updated: