Last updated 1 year ago
Gets the average value in the column filtered by the condition
AvgIf(column, [condition])
column - A column to calculate an average for
column
[condition] - [optional] - Condition to filter values in the column
[condition]
AvgIf(column1, column2 > 10) → 31.14 AvgIf(column2, column2 < Pi()) → 2