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)
Was this information helpful?
Thank you for your feedback!
Thank you for your feedback!
If you can't find what you need, don't hesitate to send us a comment.
Any questions?
Check out the GoodData community.