I am creating charts/tables on a Wave Dashboard using a small number of datasets that I've created using dataflows and recipes. What I want to do now is to query (i.e., somehow get data) from two of these datasets and combine these numbers in the same chart/table. Here's a simple illustration:
Dataset 1 - unique contacts - unique on contact_ID. Dataset 2 - contact history - unique on combination of contact_id and campaign_id (campaign to contact = many to many)
I want to pull the TOTAL number of unique contacts and combine this with the number of unique contacts for a given campaign.
In traditional SQL, I would do this by combining two independent queries via a UNION. Anyway to do in Wave? I have been playing with the SAQL but can't quite seem to get it. Many thanks!