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

Function measureBetweenNotEqual

measureBetweenNotEqual( measure, valueA, valueB, config?): Filter

Creates a filter to isolate a measure value between but not equal to two given numbers.

Parameters

ParameterTypeDescription
measureBaseMeasure | CalculatedMeasureMeasure to filter by
valueAnumberMin value
valueBnumberMax value
config?BaseFilterConfigOptional configuration for the filter

Returns

Filter

A filter instance

Example

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

filterFactory.measureBetweenNotEqual(
  measureFactory.average(DM.Commerce.Revenue),
  50,
  100
)
Last Updated: