avg_ifs

statistics

Average with multiple conditions

Syntax

avg_ifs(values, mask1, mask2, ...)

values (array)

The values to calculate average from

mask1 (boolean expression)

First condition to filter values

mask2 (boolean expression) optional

Additional conditions to filter values

number

The average of values where all masks are true

Average price of in-stock electronics

Input:

avg_ifs(.price, .category == "electronics", .in_stock)

Output:

299.99

The avg_ifs() function calculates the average of values where multiple conditions (masks) are all true, enabling multi-criteria aggregation.

Use avg_ifs() for calculating averages based on multiple criteria, combining several conditions without nested filter operations.