RollingMin
RollingMin calculates a window-based rolling minimum in an updateBy table operation. The rolling minimum can be calculated using forward and/or backward windows.
Syntax
RollingMin(revTicks, fwdTicks, pairs)
RollingMin(revTicks, pairs)
RollingMin(timestampCol, revTime, fwdTime, pairs)
RollingMin(timestampCol, revTime, pairs)
RollingMin(timestampCol, revDuration, pairs)
RollingMin(timestampCol, revDuration, fwdDuration, pairs)
Parameters
| Parameter | Type | Description |
|---|---|---|
| revTicks | long | The look-behind window size in ticks (rows). If positive, it defines the maximum number of rows before the current row that will be used. If negative, it defines the minimum number of rows after the current row that will be used. |
| fwdTicks | long | The look-forward window size in ticks (rows). If positive, it defines the maximum number of rows after the current row that will be used. If negative, it defines the minimum number of rows before to the current row that will be used. |
| pairs | String... | The input/output column name pairs. |
| timestampCol | String | The name of the timestamp column. |
| revDuration | Duration | The look-behind window size in Duration. |
| fwdDuration | Duration | The look-forward window size in Duration. |
| revTime | long | The look-behind window size in nanoseconds. |
| fwdTime | long | The look-forward window size in nanoseconds. |
Returns
An UpdateByOperation to be used in an updateBy table operation.
Examples
The following example performs an updateBy on the source table using four row-based RollingMin operations. Excluding the first operation, each operation uses different revTicks and fwdTicks values to show how they affect the output.
rng = new Random()
source = emptyTable(10).update("X = rng.nextInt(25)")
opRollMin = RollingMin(3, "RollingMinimum = X")
opPrior = RollingMin(3, -1, "WindowPrior = X")
opPosterior = RollingMin(-1, 3, "WindowPosterior = X")
opMiddle = RollingMin(1, 1, "WindowMiddle = X")
result = source.updateBy([opRollMin, opPrior, opPosterior, opMiddle])
- source
- result