sumBy
sumBy returns the total sum for each group. Null values are ignored.
Caution
Applying this aggregation to a column where the sum cannot be computed will result in an error. For example, the sum is not defined for a column of string values.
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 sum for each group.
Examples
In this example, sumBy returns the sum of the whole table. Because a sum cannot be computed for the string column X and Y, these columns are dropped before applying sumBy.
In this example, sumBy returns the sum, as grouped by X. Because a sum cannot be computed for the string column Y, this column is dropped before applying sumBy.
In this example, sumBy returns the sum, as grouped by X and Y.