Guides

Reference

Powered By GitBook

Partitioned variable methods

Category: aggregate

Any value

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Average

Return type:

`float`

Fields:

required:

`true`

input type: variable

allowed type(s):

`integer | float`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Count

Return type:

`integer`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: boolean

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Logical and

Return type:

`boolean`

Fields:

required:

`true`

input type: variable

allowed type(s):

`boolean`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Logical or

Return type:

`boolean`

Fields:

required:

`true`

input type: variable

allowed type(s):

`boolean`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Max

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Min

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

String aggregate

Return type:

`string`

Fields:

required:

`true`

input type: variable

allowed type(s):

`string`

required:

`false`

input type: literal

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Sum

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`integer | float`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`false`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Category: navigation

First value

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Lag

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

Last value

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Lead

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

Nth value

Return type:

`dynamic`

Fields:

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: literal

allowed type(s):

`integer`

required:

`true`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: literal

allowed type(s):

`integer`

required:

`false`

input type: literal

allowed type(s):

`integer`

Percentile (continuous)

Return type:

`float`

Fields:

required:

`true`

input type: variable

allowed type(s):

`integer | float`

required:

`true`

input type: literal

allowed type(s):

`float`

required:

`true`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

Percentile (discrete)

Return type:

`float`

Fields:

required:

`true`

input type: variable

allowed type(s):

`integer | float`

required:

`true`

input type: literal

allowed type(s):

`float`

required:

`true`

input type: enum

allowed type(s):

`any`

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

Category: numbering

Cumulative distribution

Return type:

`float`

Fields:

required:

`false`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: variable

allowed type(s):

`any`

required:

`true`

input type: enum

allowed type(s):

`any`

Dense rank