medianBy

medianBy returns the median value for each group. Null values are ignored.

Syntax

Parameters

ParameterTypeDescription
groupByColumnsString...

The column(s) by which to group data.

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

The column(s) by which to group data.

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

The column(s) by which to group data.

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

Returns

A new table containing the median value for each group.

Examples

In this example, medianBy returns the median value for each column.

In this example, medianBy returns the median value, as grouped by X.

In this example, medianBy returns the median value, as grouped by X and Y.