FILTER

Description

Filter data on a vector, grouped scalar or grouped vector, by comparing with a threshold. Only data which fulfills that boolean condition is kept.

Filter(Vector<any>, Scalar<Text>, Scalar<any>)

FILTER(vector: Vector<any>, 
       comparisonSymbol: Scalar<Text>, 
       threshold: Scalar<any>): Vector<any>

Filter data in the given vector by comparing with the threshold.

Parameters

Parameter	Description
vector	A vector whose data is to be filtered
comparisonSymbol	The comparison symbol. One of: <, <=, =, !=, >=, >
threshold	A scalar which is used to filter data.

Returns

Vector of same type as from the first function parameter, with filtered data.

Examples

Filter events, so that only values > 1000 are kept in the vector.

FILTER($GridPowerConsumption, '>', 1000)

---

Filter(GroupedScalar<any, any>, Scalar<Text>, Scalar<any>)

FILTER(groupedScalar: GroupedScalar<any, any>, 
       comparisonSymbol: Scalar<Text>, 
       threshold: Scalar<any>): GroupedScalar<any, any>

Filter data in the given grouped scalar by comparing with the threshold. Empty groups are removed from the grouped scalar.

Parameters

Parameter	Description
groupedScalar	A vector whose data is to be filtered.
comparisonSymbol	The comparison symbol. One of: <, <=, =, !=, >=, >
threshold	A scalar which is used to filter data.

Returns

Grouped scalar of same type as from the first function parameter, with filtered data.

Examples

Filter events in the grouped scalar, so that only values > 1000 are kept in the vector.

FILTER(MIN(GROUP_BY_DEVICE($PowerConsumption)), '!=', 0)

---

Filter(GroupedVector<any, any>, Scalar<Text>, Scalar<any>)

FILTER(groupedVector: GroupedVector<any, any>, 
       comparisonSymbol: Scalar<Text>, 
       threshold: Scalar<any>): GroupedVector<any, any>

Filter data in the given grouped vector by comparing with the threshold. Empty groups are removed from the grouped vector.

Parameters

Parameter	Description
groupedVector	A vector whose data is to be filtered.
comparisonSymbol	The comparison symbol. One of: <, <=, =, !=, >=, >
threshold	A scalar which is used to filter data.

Returns

Grouped vector of same type as from the first function parameter, with filtered data.

Examples

Filter events, so that only values > 1000 are kept in the grouped vector.

FILTER(GROUP_BY_DEVICE($PowerConsumption), '<=', 200)