HomeDocumentationChangelog
HomeRequest DemoContact
HomeRequest DemoContact

Filters

Use filters to only include datapoints which fulfills a specified filter in the metric calculation.

FiltersDescription
No FilterNo filter applied to data. Process all available datapoint in a Window.
Boolean filterEnsures that a Boolean value is either true or false.
EnumEnsures that a string only contains values from a fixed set of specified values.
NullEnsures that a field value is NULL.
StringEnsures that a string adheres to certain criteria.
Threshold filterEnsures that a numeric value is either under or over a certain threshold.

πŸ‘

Example

Want to count only the NULL values for a certain field? Then you can use a Volume Validator and apply a NULL filter.

Boolean filter

Filter Boolean datapoints as either true or false for a specified field.

Configuration parameters

Parameter nameParameter values
Filter typeBoolean filter
FieldList of source fields with Boolean data types
OperatorIs true

Is false

Enum

Filter string datapoints based on a set of specified values.

Configuration parameters

Parameter nameParameter values
Field List of source fields with string data types
OperatorIs in

Is not in
ValueList of strings

Null

Filters datapoints that are Null for a specified field.

Configuration parameters

Parameter nameParameter value
FieldList of source fields
OperatorIs
Is not

String

Filter string datapoints to match specific criteria.

Configuration parameters

Parameter nameParameter values
FieldList of source fields with string data types
OperatorIs empty
Is not empty
Contains
Does not contain
Starts with
Ends with
Is exactly
Regex
ValueString

Regular expressions (regex)

You can use certain regex syntax in the value field when you select regex as the operator for string filters.

The exact syntax is compatible with the Rust regex library. For information on that syntax, refer to Rust - regex crate syntax.

Note: When you configure a filter on a Data Warehouse source type, you must use a regex syntax supported by the Data Warehouse. In this case, we recommend that you consult the regex library for your Data Warehouse.

Threshold Filter

Filter individual datapoints based on a set value.

Configuration parameters

Parameter nameParameter values
FieldList of source fields with numeric data types
Operator (*)Equal to
Not equal to
Greater than
Greater than or equal to
Less than
Less than or equal to
ValueFloat number

* Specifies the 'allowed region'. For example, Greater than or equal than 5 specifies the allowed region, and all values strictly less than five are be filtered.