Skip to content
When you manage data, that’s quite often that you would like to rank them and to display the N first value of it.
Here is a very short and easy tutorial to use the Rank() function, combine with a slider to display that quickly !
My Longer Running Distance
As you may know, I love to run a lot, and I of course manage my historical data running with coda.
Let’s consider a few running sessions with the following table Running Sessions
Running Sessions
I would like to rank my sessions according to the distance I ran. For this, I create a number column distance_rank, with the following formula :
Rank(thisRow.Distance,[Running Sessions].Distance)
It will generate a ranking, than you can use to sort your data :
Ranked Running Sessions
💡 Display the N best value ?
OK, you may say that this can be made easily with only sorting distance, directly. But the power of the rank function is to use it, for example, combine with a slider to display the N best (or worst) value, using filter in your running sessions table :
thisRow.[distance rank]<=slider_rank
Show best running sessions !
00
0Show N best value ?
Date
Name of Activity
Distance
No results from filter
Hope you enjoy this little trick ! Please visit to leave any comment, suggestion, or see my twitter feed !
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.