Relative Time
Validating the difference between two timestamp fields.
Validator Overview
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.
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 |
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. |
Updated 12 days ago