Syntax
GROUPAVERAGE(<number>)
Description
Returns the average value of a group by creating a sum for all values in the group and dividing by the number of values. A GROUPBY() function must first be used in order to then find the average arguments of another column in relation to it. The value of the GROUPAVERAGE() must be a number and is returned as a float.
Empty or <null> records of a group aren't calculated into GROUPAVERAGE().
...
| user_time_zone | GROUPAVERAGE returns |
|---|---|
| Alaska | 27 |
| Central Time (US & Canada) | 166.6666667 |
| London | 162 |
| Melbourne | <error> |
| Pacific Time (US & Canada) | 4800.666667 |
| Sydney | 27 |