javg() or average()
count()
first()
last()
max()
median()
min()
sum()
unique()
stddev()
stddevp()
var()
varp()
percentile_cont()
percentile_disc()
regr_intercept()
regr_slope()
regr_r2()
grouping()
Windowing Functions
coalesce
Previous Versions
min()
Returns the minimum value of a dimension or measure field.
Example - Find the Smallest Opportunity For Each Account
1q = load "Ops";
2q = group q by 'Account_Name';
3q = foreach q generate 'Company' as 'Company', min('Amount') as 'Smallest Deal';Example - Find the First Value in List of Airline Destinations per Origin
For dimensions, min() sorts the values alphabetically and the first value is returned.
1q = load "Airlines";
2q = group q by 'origin';
3q = foreach q generate 'origin' as 'Origin', min('dest') as 'Min Destination';See Also
j