Aggregate

Any value

Returns any value from the input or NULL if there are zero input rows –> learn more

ANY_VALUE(@variable)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-

Average

Returns the average of all non-null values –> learn more

AVG(@variable)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any integer, float	true	-

Count

Returns the count of all non-null values –> learn more

COUNT([@distinct ]@variable)

Return type

integer

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	false	(*)
@distinct	boolean	any boolean	true	-

Logical and

Returns the logical AND of all non-NULL expressions –> learn more

LOGICAL_AND(@variable)

Return type

boolean

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any boolean	true	-

Logical or

Returns the logical OR of all non-NULL expressions –> learn more

LOGICAL_OR(@variable)

Return type

boolean

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any boolean	true	-

Max

Returns the maximum value of all non-null inputs –> learn more

MAX(@variable)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-

Min

Returns the minimum value of all non-null inputs –> learn more

MIN(@variable)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-

String aggregate

Returns a string obtained by concatenating all non-null values –> learn more

STRING_AGG([@distinct ]@variable[, @delimiter][ LIMIT @limit])

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-
@delimiter	literal	any Redivis type	false	(",")
@distinct	boolean	any boolean	true	-
@limit	literal	any Redivis type	false	-

Sum

Returns the sum of all values, ignoring nulls –> learn more

SUM(@variable)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any integer, float	true	-