MedianIf

Gets the median value in the column filtered by the condition

MedianIf(column1, column2 == "20") → 30
MedianIf(column1, column1 > Round(column2)) → 6

Inputs

MedianIf(column, [condition])

  • column - A column to calculate the median value for

  • [condition] - [optional] - Condition to filter values in the column