RANK

The RANK function returns a group with predefined keys from a table and values from a winner column. This is useful to compose personalized texts.

Details
It can also return a list of groups (columns)
The columns are chosen using a point-based system.
Syntax
RANK(table, [number])
Argument name
Description
table
Required
Table to be evaluated.
number
Optional
Number of groups (columns) to return. By default will return 1.
Table syntax
Column name
Description
key
Required
Column with the group keys.
<other_columns>
Required
Column values. The header(s) with higher values will be chosen.
Examples
Example 1
If:
type1=4, type2=6, type3=2
And the table is:
table
RANK(table) will return this group:
title: 'Title 2'
subtitle: 'Subtitle2'
RANK(table, 2) will return a list with these two groups:
title: 'Title 2'
subtitle: 'Subtitle2'
​
title: 'Title 1'
subtitle: 'Subtitle1'
​

PROPERTY

RECIDS

Last modified 2yr ago

Argument name	Description
table Required	Table to be evaluated.
number Optional	Number of groups (columns) to return. By default will return 1.

Column name	Description
key Required	Column with the group keys.
<other_columns> Required	Column values. The header(s) with higher values will be chosen.