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 TypesDescription
No FilterNo filter applied to data. Process all available datapoint in a Window.
Boolean FilterEnsures that a Boolean value is either true or false.
Enum FilterEnsures that a string only contains values from a fixed set of specified values.
Null FilterEnsures that a field value is NULL.
String FilterEnsures that a string adheres to certain criteria.
Threshold filterEnsures that a numeric value is either under or over a certain threshold.
SQL FilterFilter 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 a NULL 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.