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
| Parameter | Type | Description |
|---|---|---|
measure | BaseMeasure | CalculatedMeasure | Measure to filter by |
valueA | number | Min value |
valueB | number | Max value |
config? | BaseFilterConfig | Optional configuration for the filter |
Returns
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
)