You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.

MIN

The MIN function returns the minimum value of all numbers in the set (e.g., Salary Paid).

Syntax

SELECT MIN(…)
SELECT MIN(fact)

Examples

The MIN of the Opportunity Amount fact is the lowest opportunity amount value on record:

SELECT MIN(Opportunity_Amount)
SELECT MIN(metric that uses fact)