avgif
avgif — aggregate function to return the average of rows that match the query's predicate.
DESCRIPTION
The avgif() function returns the average of the values for which the specified numeric column is not null and for which the predicate evaluates to true. The predicate expression can be any valid expression on any column in a table, is not restricted to values from the specified column.
SEE ALSO
This LiveView aggregate function is based on the avgif aggregate function in the StreamBase expression language.