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
avg() or average()
Returns the average of the values of a measure field.
Example - Calculate the Average Amount of an Opportunity Grouped by Type
Use avg() to compare the average size of opportunities for each account type.
1q = load "DTC_Opportunity";
2q = group q by 'Account_Type';
3q = foreach q generate 'Account_Type' as 'Account_Type', avg('Amount') as 'avg_Amount';See Also
j