You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.
MAX
The MAX function returns the maximum value of all numbers in the set (e.g., Salary Paid).
Syntax
SELECT MAX(…)
SELECT MAX(fact)
Examples
The MAX of the Store Sales fact is the highest sales transaction value on record:
SELECT MAX(Sales)
SELECT AVG(metric that uses fact)