AVG_IF (window)

Function AVG_IF is also found in the following categories: Aggregate functions.

Syntax

Standard

Extended

AVG_IF( expression, condition
        TOTAL | WITHIN ... | AMONG ...
      )

More info:

TOTAL, WITHIN, AMONG

AVG_IF( expression, condition
        TOTAL | WITHIN ... | AMONG ...
        [ BEFORE FILTER BY ... ]
      )

More info:

TOTAL, WITHIN, AMONG
BEFORE FILTER BY

Description

Returns the average of all values that meet the condition condition. If the values don't exist, it returns NULL. Applicable to numeric data types only.

Argument types:

expression — Fractional number | Integer
condition — Boolean

Return type: Same type as (expression)

Examples

AVG_IF([Profit], [Category] = 'Office Supplies' TOTAL)

AVG_IF([Profit], [Category] = 'Office Supplies' WITHIN [Date])

AVG_IF([Profit], [Category] = 'Office Supplies' AMONG [Date])

Data source support

ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.

AVG

COUNT