Newer Version Available

This content describes an older version of this product. View Latest

min()

Returns the minimum value of a 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';