You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.
AVG
The AVG function returns the average value of all numbers in the set (e.g., Salary paid). Null values are ignored.
Syntax
SELECT AVG(…)
SELECT AVG(fact)
Examples
The metric AVG of Payment is computed by adding all payment transactions together and dividing by the number of payment transactions:
SELECT AVG(Payment)
SELECT AVG(metric that uses fact)