Navigation

First value

Returns the value of a variable for the first row in a given analytic window. –> learn more

FIRST_VALUE(@variable[ @ignore_null NULLS])

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-
@ignore_null	enum	any of: IGNORE, RESPECT	false	(Ignore nulls (default))

Lag

Returns the value of a variable on a preceding row within the analytic window –> learn more

LAG(@variable, @literal[, @default_value])

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-
@literal	literal	any integer	false	(1)
@default_value	literal	any Redivis type	false	(NULL)

Last value

Returns the value of a variable for the last row in a given analytic window. –> learn more

LAST_VALUE(@variable[ @ignore_null NULLS])

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-
@ignore_null	enum	any of: IGNORE, RESPECT	false	(Ignore nulls (default))

Lead

Returns the value of a variable on a subsequent row within the analytic window –> learn more

LEAD(@variable, @literal[, @default_value])

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-
@literal	literal	any integer	false	(1)
@default_value	literal	any Redivis type	false	(NULL)

Nth value

Returns the value at the Nth row of a given window frame. –> learn more

NTH_VALUE(@variable, @literal[ @ignore_null NULLS])

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-
@literal	literal	any integer	true	-
@ignore_null	enum	any of: IGNORE, RESPECT	false	(Ignore nulls (default))

Percentile (continuous)

Computes the specified percentile value for a variable within an ordered partition, with linear interpolation. –> learn more

PERCENTILE_CONT(@variable, @literal[ @ignore_null NULLS])

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any integer, float	true	(variable)
@literal	literal	any float	true	(Value between [0, 1])
@ignore_null	enum	any of: IGNORE, RESPECT	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

PERCENTILE_DISC(@variable, @literal[ @ignore_null NULLS])

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any integer, float	true	(variable)
@literal	literal	any float	true	(Value between [0, 1])
@ignore_null	enum	any of: IGNORE, RESPECT	false	(Ignore nulls (default))