PICKZEN
Search
⌃K

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'
Last modified 2yr ago