avg_if

statistics

Average of values where mask is true

Syntax

avg_if(values, mask)

values (array)

The values to calculate average from

mask (boolean expression)

Condition to filter values

number

The average of values where mask is true

Average sales in North region

Input:

avg_if(.sales, .region == "North")

Output:

Average score of passing students

Input:

avg_if(.score, .passed)

Output:

88.5

The avg_if() function calculates the average of values where a condition (mask) is true, enabling conditional aggregation.

Use avg_if() for calculating averages based on specific criteria, filtering data inline without separate filter operations.