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