function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
petec@i2isyspetec@i2isys 

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';