How do I change the order of my rank on a table calculation? (ascending, descending)

[LookerExperts]

Knowledge Drop

Last Tested: Jan 21, 2019
 

When you do a rank in table calculations it will show you the rank in descending order so the largest value of the field being ranked as number one. Like so:

rank(${price}, ${price})

Price	Price Rank
$5	3
$28	1
$13	2

To see the rank in ascending order, you can simply make the numbers negative, so that they sort the opposite way:

rank((-${price}, (-${price}))

So you can see this:

Price	Price Rank
$5	1
$28	3
$13	2

This content is subject to limited support.