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'