AvgIf

Gets the average value in the column filtered by the condition

AvgIf(column1, column2 > 10) → 31.14
AvgIf(column2, column2 < Pi()) → 2

Inputs

AvgIf(column, [condition])

  • column - A column to calculate an average for

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

Last updated