Validating the difference between two timestamp fields. Calculates either the mean time difference, minimum time difference, or maximum time difference.
|Step||Required||Parameters / Options|
|Validator type||✅||Relative time|
|Config||✅||Source field minuend:|
Timestamp field to monitor
|Config||✅||Source field minuend|
Reference timestamp to subtract (reference)
|Config||Initialize with backfill (checkbox)|
1, Select a configured Segmentation
2. Unsegmented (default)
Select a configured Window
No filter (default)
Less than or equal
Greater than or equal
Numeric value to threshold on
*1 Only applicable for
*2 Only applicable for
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.
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
Updated 15 days ago