Validator Overview

The Relative Time validator calculates the difference between two timestamp fields. This validator is useful for validating processing times, delivery durations, or ensuring events occur within expected time windows relative to each other.

You can configure the Relative Time validator to calculate the following metrics:

Metric Options	Description
Maximum Difference	Validates the maximum difference between two date fields.
Minimum Difference	Validates the minimum difference between two date fields.
Mean Difference	Validates the mean difference between two date fields.

The relative time validator calculates the time difference on two fields for each record:

Time Difference = Source field - Field to subtract

The computed metric is then either max, min, or mean of the time difference within a window. The calculated fields must be valid timestamps.

📘
The difference can be negative if the timestamp in the "Field to subtract" lies in the future relative to source field.

Metric Configuration Parameters

Parameters	Description
Metric	Select the metric to calculate. See the Metric Options table.
Field	Select a timestamp field from the list of available timestamp fields.
Field to subtract	Select a timestamp field to validate against.
Filter	(Optional) Select from a list of filters or create a new filter to specify which records to include.
Window	Select from a list of windows or create a new window to specify how to aggregate the data.
Segmentation	(Optional) Apply segmentation to analyze data in separate groups. Default is `Unsegmented`.