TopN
Keeps only the highest (or lowest) N rows ranked by one column, such as the top 10 customers or the five biggest expenses. It sorts by the column you pick, keeps the first N rows, and drops the rest.
Inputs
| Input | Accepts | Required |
|---|---|---|
Table | Table | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Table |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
N | — | How many rows to keep, as a whole number (e.g. 10). |
Column | — | Choose a column from the connected table. The column that decides the ranking (e.g. Revenue). |
Ascending | — | false (default) keeps the N largest values, a true "top 10". Set true to keep the N smallest, the bottom N. |
Example
Your Customers table has 1,400 accounts with an Annual_Revenue column. Set
N to 10 and Column to Annual_Revenue, and the result is your ten largest
accounts, biggest first, as its own tab. Flip Ascending to true to see the ten
smallest instead.
Tips
- The result stays sorted, so it feeds a bar chart directly: labels from the name column, values from the ranking column.
- Asking for more rows than the table has returns the whole table.