avg() (aggregation function)

  • Article
  • 2 minutes to read

Calculates the average (arithmetic mean) of Expr across the group.

  • Can only be used in context of aggregation inside summarize

Syntax

avg (Expr)

Arguments

  • Expr: Expression that will be used for aggregation calculation. Records with null values are ignored and not included in the calculation.

Returns

The average value of Expr across the group.