Navigation
First value
Returns the value of a variable for the first row in a given analytic window. –> learn more
Return type
dynamic (input-dependent)
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| any Redivis type | true | - | |
| any of: | false | (Ignore nulls (default)) |
Lag
Returns the value of a variable on a preceding row within the analytic window –> learn more
Return type
dynamic (input-dependent)
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| any Redivis type | true | - | |
| any integer | false | (1) | |
| any Redivis type | false | (NULL) |
Last value
Returns the value of a variable for the last row in a given analytic window. –> learn more
Return type
dynamic (input-dependent)
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| any Redivis type | true | - | |
| any of: | false | (Ignore nulls (default)) |
Lead
Returns the value of a variable on a subsequent row within the analytic window –> learn more
Return type
dynamic (input-dependent)
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| any Redivis type | true | - | |
| any integer | false | (1) | |
| any Redivis type | false | (NULL) |
Nth value
Returns the value at the Nth row of a given window frame. –> learn more
Return type
dynamic (input-dependent)
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| any Redivis type | true | - | |
| any integer | true | - | |
| any of: | false | (Ignore nulls (default)) |
Percentile (continuous)
Computes the specified percentile value for a variable within an ordered partition, with linear interpolation. –> learn more
Return type
float
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| true | (variable) | ||
| any float | true | (Value between [0, 1]) | |
| any of: | false | (Ignore nulls (default)) |
Percentile (discrete)
Computes the specified percentile value for a variable within an ordered partition. Returns the first sorted value with cumulative distribution greater than or equal to the percentile. –> learn more
Return type
float
Parameters
Last updated