Tableau CRM SAQL Developer Guide

Overview
Quick Start
Examples
SAQL Reference
SAQL Basic Elements
SAQL Operators
SAQL Statements
cogroup
fill
filter
foreach
group-by
group-by rollup
limit
load
offset
order
sample
timeseries
union
SAQL Functions
Query Performance
PDF

Newer Version Available

This content describes an older version of this product. View Latest

union

Combines multiple result sets into one result set. The result sets must have the same field names and structure. You can use a different dataset to create each result set, or you can use the same dataset.

Syntax

Example

Example

You want to see how each rep compares to the average for deals won. You can make this comparison by appending these two result sets together:
  • Total amount of opportunities won for each rep
  • Average amount of opportunities won for all reps
Then use union to append the two result sets.

First, show the total amount of won opportunities for each rep.

The resulting graph shows the sum of amount for each rep.

Diagram showing the sum of amounts for each rep.

Next, calculate the average of the sum of the amounts for each rep using the average function.

Because the two data streams have the same field names and structure, you can use union to combine them.

The resulting graph contains the sum of amounts by each rep together with the average amount per rep.

Diagram showing the sum of amounts for each rep, plus the average amount.

Combine the SAQL fragments to get the complete SAQL statement.