minBy

minBy returns the minimum value for each group. Null values are ignored.

Syntax

Parameters

ParameterTypeDescription
columnNamesString...

The column(s) by which to group data.

  • NULL returns the minimum value for each column in the table.
  • "X" will output the minimum value of each group in column X.
  • "X", "Y" will output the minimum value of each group designated from the X and Y columns.
columnNamesColumnName...

The column(s) by which to group data.

  • NULL returns the minimum value for each column in the table.
  • "X" will output the minimum value of each group in column X.
  • "X", "Y" will output the minimum value of each group designated from the X and Y columns.
columnNamesCollection<String>

The column(s) by which to group data.

  • NULL returns the minimum value for each column in the table.
  • "X" will output the minimum value of each group in column X.
  • "X", "Y" will output the minimum value of each group designated from the X and Y columns.

Returns

A new table containing the minimum value for each group.

Examples

In this example, minBy returns the minimum value for each column.

In this example, minBy returns the minimum value, as grouped by X.

In this example, minBy returns the minimum value, as grouped by X and Y.