Skip to main content
AVG

Calculates the average value of a specified numeric field across a range or partition

Updated over 2 weeks ago

Description

The AVG() function calculates the average value of a specified numeric field across a range or partition. This function is useful for determining the mean value in data analysis and reporting.

Syntax

AVG(number)

Output

numeric

Variables

  1. number: the numeric field to be averaged.

Example

AVG(Value) OVER (Partition by Group)

ID

Group

Value

AVG

1

A

10

15

2

A

20

15

3

A

15

15

4

B

30

35

5

B

40

35

Did this answer your question?