SAQL simply explained – Part 4
Rikke Hovgaard
Work with data. Speak & blog about data. Data Cloud and CRM Analytics focused.
What we have covered so far in the SAQL series have been some basic features, however, it can be a lot more powerful. Let’s say you have two different datasets you want to use for a single query; it could be cases and opportunities for an account. Well, with SAQL we can leverage co-grouping to join datasets or streams in a single query. So let’s have a look at this function.
Cogrouping or data blending
Imagine you want to look at how many opportunities and cases one account has in the same chart using Einstein Analytics. Generally, you would not have this information in a single dataset as opportunities and cases are not related other than via a relation to the account object. Yes, if you use your dataflow skills you would be able to create this dataset, however for the purpose of illustrating how co-grouping works we will assume you have two datasets; opportunities and cases both generated from the Sales Analytics Templated App.
Tableau CRM(Einstein Analytics) || Salesforce Developer and Admin
5yI really like your blog Rikke Hovgaard, keep doing and help beginners like me. Thank you! I have one question here, from case stream we can only get aggregation fields other than Account name, right? Let's consider we have caseowner dimension in case stream and we want to get that dimension in the final output. How can we do that?
Head of Salesforce Centre of Excellence
5yReally helpful blog posts!
Digital Transformation @Salesforce | corporate pirate | RVP Transformation Consulting - EMEA North | Salesforce Certified Technical Architect - CTA | public speaker | ⛷️⛳
5yLove how you turn something like a jetlag into something positive like this Rikke =)
Team Lead Salesforce Solution at delaware BeLux | CRM, Customer Service, Marketing Automation, B2B & B2C Customer Experience | Make data actionable across teams
5yJasper Casselman Might be interesting for you!