Rank
Assigns a rank number to every value in a column, so you can see where each row stands relative to the rest. Rank 1 goes to the smallest value, counting upward from there, which fits wherever lower is better, such as expense ratios or days to close.
Inputs
| Input | Accepts | Required |
|---|---|---|
Series | Series (a list of numbers) | Yes |
Method | Text | Optional |
Outputs
| Output | Produces |
|---|---|
Result | Series (a list of numbers) |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Method | Dense | One of Dense, Min, Standard. Controls what happens on ties: Dense gives tied values the same rank with no gap after (1, 2, 2, 3), Min gives tied values the lowest rank in the group and skips the next (1, 2, 2, 4), Standard averages the tied positions (1, 2.5, 2.5, 4). |
Example
A Funds table has 40 rows with an Expense_Ratio column. Rank that column
and the cheapest fund gets rank 1, the priciest gets rank 40. Two funds both
charging 0.35% share a rank; with Method set to Dense the next fund down the
list still gets the next whole number, so the ranking reads 1, 2, 2, 3 with no
gap.
Tips
When higher is better (ranking reps by Bookings, say), keep the ranks as they
are and read rank 40 as first place, or pair the result with a descending Sort
so the table displays largest first.