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
max()
Returns the maximum value of a dimension or measure field.
Example - Find the Largest Opportunity for Each Account
1q = load "Ops";
2q = group q by 'Account_Name';
3q = foreach q generate 'Company' as 'Company', max('Amount') as 'Largest Deal';Example - Find the Last Value in List of Airline Destinations per Origin
For dimensions, max() sorts the values alphabetically and the last value is returned.
1q = load "Airlines";
2q = group q by 'origin';
3q = foreach q generate 'origin' as 'Origin', max('dest') as 'Max Destination';See Also
j