Aggregate
Last updated
Last updated
Returns any value from the input or NULL if there are zero input rows –> learn more
dynamic (input-dependent)
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
Returns the average of all non-null values –> learn more
float
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
Returns the count of all non-null values –> learn more
integer
Returns the logical AND of all non-NULL expressions –> learn more
boolean
Returns the logical OR of all non-NULL expressions –> learn more
boolean
Returns the maximum value of all non-null inputs –> learn more
dynamic (input-dependent)
Returns the minimum value of all non-null inputs –> learn more
dynamic (input-dependent)
Returns a string obtained by concatenating all non-null values –> learn more
string
Returns the sum of all values, ignoring nulls –> learn more
dynamic (input-dependent)
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@variable
any Redivis type
true
-
@variable
true
-
@variable
any Redivis type
false
(*)
@distinct
any boolean
true
-
@variable
any boolean
true
-
@variable
any boolean
true
-
@variable
any Redivis type
true
-
@variable
any Redivis type
true
-
@variable
any string
true
-
@delimiter
any Redivis type
false
(",")
@distinct
any boolean
true
-
@limit
any Redivis type
false
-
@variable
true
-