+ Start a Discussion

How do you edit SAQL so that a table summarizes columns at the bottom and at the end of each row?

SwethaSwetha (Salesforce Developers) 
HI Petec,
The article 
https://salesforce.stackexchange.com/questions/321928/using-saql-to-place-total-at-bottom-of-results-instead-of-alphabetically-ordered explains summarizing rows at the end of each column. 

Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
AnudeepAnudeep (Salesforce Developers) 
Have you tried using the sum() aggregate function (https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_fn_agg_sum.htm)
q = load "Meetings";
q = group q by 'Company';
q = foreach q generate 'Company' as 'Company', sum('MeetingDuration') as 'sum_meetings';