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
Was this helpful?