HomeDocumentationRecipesChangelog
HomeRequest DemoContact
Documentation
HomeRequest DemoContact

Relative Time

Validating the difference between two timestamp fields.

Validator Overview

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

Metric OptionsDescription
Maximum DifferenceValidates the maximum difference between two date fields.
Minimum DifferenceValidates the minimum difference between two date fields.
Mean DifferenceValidates 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.

📘

Note

The difference can be negative if the timestamp in the target field lies in the future, relative to data time field timestamp.

Metric Configuration Parameters

Parameters

Description

Options

Metric

Select the metric to calculate.

Minimum difference
Maximum difference
Mean difference

Field

Select a timestamp field to use for the calculation.

List of available timestamp fields.

Field to Subtract

Select a timestamp field to use for the calculation.

List of available timestamp fields.

Filter

(Optional) Use filters to specify which records to include in the calculation.

List of existing filters or create a new filter.

Window

Use windows to define the time-range over which the data is aggregated.

List of existing windows or create a new window.

Segmentation

Use segmentation to break the data into separate groups for analysis.

List of existing segmentations, Unsegmented (default), or create a new segmentation.

Initialize using historic data

Start the validator with historical data to prime the anomaly detection algorithms.