Calculates the time interval between rows. It is not necessary to sort rows before applying this operator. They are sorted by the operator.
Configuration
Input settings of existing table
Settings
Want to learn more?
Examples
Example: Calculate intervals with Date + time (to)
Situation
The table with time intervals has to be set so that the "from column"(2) that follows after the "to column"(1) in the upper row is on a later date than the previous "to column"(1) in the upper row.
Settings
In this example we want to look are the time intervals that are greater than 3 days.
Result
2-1=R If the "Interval Result" is less than 3 or 3 the result will be NULL.
Project File
-
Example: Calculate intervals
Situation
Calculates the time interval between each row.
Settings
In this example we want to look are the time intervals that are greater than 3 days..