Examples | Analytics SAQL Reference | Salesforce Developers

Analyze Your Data Over Time
Use SAQL date functions for advanced time-based analysis.

Combine Data from Multiple Datasets with cogroup
You can combine data from two or more data streams into a single data stream using cogroup. The data streams must have at least one common field.

Calculate Values over a Dynamic Range with Windowing
Windowing functions perform calculations over a dynamic range. You can use time ranges like year to date to answer questions such as “what is the running total of deals for this year?” You can also calculate partial totals, either for specific segments of data or specific time windows.

Append Datasets using union
You can append data from two or more data streams into a single data stream using union. The data streams must have the same field names and structure.