Analytics SAQL Developer Guide
jlast()
Returns the last value in the tuple for the specified field.
Use last() to return the last value of a
measure or dimension. You can also use last() to return the value of a field without grouping by
that field.
Example - Return the Last Industry for an Account Owner
Your reps own opportunities in several industries. You need a list of rep names with their last industry, where industry is sorted alphabetically. Group by account owner and industry, sort by industry, then use first() to get the last industry.
1q = load "DTC_Opportunity_SAMPLE";
2q = group q by ('Account_Owner', 'Industry');
3q = foreach q generate 'Account_Owner' as 'Account_Owner', 'Industry' as 'Industry';
4q = order q by 'Industry';
5
6q = foreach q generate 'Account_Owner' as 'Account_Owner', last('Industry') as 'One Industry';