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:
RANK(table) will return this group:
RANK(table, 2) will return a list with these two groups:
Last updated
