maxBy
maxBy returns the maximum value for each group. Null values are ignored.
Syntax
Parameters
| Parameter | Type | Description |
|---|---|---|
| groupByColumns | String... | The column(s) by which to group data.
|
| groupByColumns | ColumnName... | The column(s) by which to group data.
|
| groupByColumns | Collection<String> | The column(s) by which to group data.
|
Returns
A new table containing the maximum value for each group.
Examples
In this example, maxBy returns the maximum value for each column.
In this example, maxBy returns the maximum value, as grouped by X.
In this example, maxBy returns the maximum value, as grouped by X and Y.