Largest
Get nth largest value as a column
What It Does
Largest adds a column containing the Nth largest value from a numeric column. N=1 gives the maximum, N=2 the second largest, etc.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Largest". It's in the Aggregate group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select (numeric) | Yes | The numeric column to find largest values in |
N | Number | Yes | Rank position (1 = largest) |
SQL generated under the hood
SELECT *, NTH_VALUE(price, 1) OVER (ORDER BY price DESC) AS max_price FROM dataRelated Operations
- Pivot - Pivot table (rows to columns)
- Window Function - Rank, row number, lead, lag
- Smallest - Get nth smallest value as a column