About Filters
You can define filters on the validator metric calculations and on the segmentation fields. The following table lists the types of filters that Validio supports:
Filter Types | Description |
---|---|
No Filter | No filter applied to data. Process all available datapoint in a Window. |
Boolean Filter | Ensures that a Boolean value is either true or false. |
Enum Filter | Ensures that a string only contains values from a fixed set of specified values. |
Null Filter | Ensures that a field value is NULL. |
String Filter | Ensures that a string adheres to certain criteria. |
Threshold filter | Ensures that a numeric value is either under or over a certain threshold. |
SQL Filter | Filter records based on a SQL WHERE statement. |
When to Configure Filters
You can configure filters on both validators and segmentations:
- Configure filters on validators to specify the datapoints to include in the metric calculation. For example, to count only the
NULL
values for a certain field, use a volume validator and apply aNULL
filter. - Configure filters on segments to specify the values to include in the segmentation. Because segments will be created before the validator metric, it’s better to apply filters related to the segments on the segmentation. Then, you can configure validators to use the filtered segmentation.
Updated 12 days ago