HomeDocumentationChangelog
HomeRequest DemoContact
HomeRequest DemoContact

Relative time

Validating the difference between two timestamp fields. Calculates either the mean time difference, minimum time difference, or maximum time difference.

Configuration

StepRequiredParametersOptions
Validator typeRelative time-
ConfigSource field minuendTimestamp field to monitor
ConfigSource field subtrahendReference timestamp to subtract (reference)
ConfigMetricMinimum difference
Maximum difference
Mean difference
ConfigBackfillInitialize with backfill (checkbox)
Source configSegmentation1. Select a configured Segmentation

Or

2. Unsegmented (default)
Source configWindowSelect a configured Window
Source configFilterNo filter (default)
Boolean
Enum
Null (*1)
String
Threshold filter
ThresholdThreshold typeFixed threshold
Dynamic threshold
Monotonic threshold
Threshold✅(*2)OperatorLess than
Less than or equal
Equal
Not equal
Greater than
Greater than or equal
ThresholdValueNumeric value to threshold on

*1 Only applicable for nullable columns.

*2 Only applicable for Fixed thresholds.

Configuration details

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

Time Difference = Source field minuend - Source field subtrahend

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 target field lies in the future, relative to data time field timestamp.

Time resolution

The time resolution parameter allows you to set a suitable resolution for your use case. All time differences are calculated in seconds and then converted into the selected resolution.

For example, selecting ‘Minute’ as resolution results in the following:

01/06 2022 18:14:19 - 01/06 2022 18:13:09 = 70 seconds = 1.17 minutes