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.
- It can also return a list of groups (columns)
- The columns are chosen using a point-based system.
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. |
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'
Last modified 2yr ago