Functions & Aggregates

The aggregate, string, and date functions you'll reach for most often when writing foreach ... generate clauses.

Aggregates

sum, avg, min, max, count, and count_distinct are the core aggregates, always used inside a foreach ... generate:

q = foreach q generate 'Region' as 'Region',
  sum('Amount') as 'TotalRevenue',
  count_distinct('AccountId') as 'Accounts';

concat(), upper(), lower(), and standard arithmetic (+ - * /) work inline:

q = foreach q generate concat('Region', " - ", 'StageName') as 'Label';

q = order q by 'TotalRevenue' desc;
q = limit q 10;

Combined, this is the classic "top 10 regions by revenue" query pattern.

Next: debugging SAQL in the Query Editor when a chart returns the wrong numbers.

Filtering & Grouping

Write SAQL filter conditions and group-by clauses, including multi-level grouping for drill-down charts.

Debugging Queries

Use the Query Editor and step-through execution to find why a chart is returning unexpected results.