Tableau CRM SAQL Developer Guide

Overview
Introduction
Use SAQL in the Tableau CRM Dashboard
Enable SAQL Logs in the Browser
Quick Start
Examples
SAQL Reference
Query Performance
PDF

Newer Version Available

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

Use SAQL in the Tableau CRM Dashboard

Use the Tableau CRM Studio user interface to modify existing SAQL queries or write new ones. Writing SAQL queries in the user interface is the easiest way to get started.
Every component in Tableau CRM uses SAQL behind the scenes. You can build a widget in a dashboard, then switch to the SAQL view to see the SAQL query for the widget. Or, you can create a lens while exploring a dataset, then switch to the SAQL view to see the SAQL query for the lens.

Let’s look at the query generated by a widget in a dashboard.

After you edit the SAQL for a widget, you may not be able to go back to the dashboard view, depending on how complex the SAQL query is.

Note

  1. In your Salesforce org, open Tableau CRM Studio, then open a dashboard. For example, open Opportunity Details.
  2. Click Edit.
    Click Edit on a sample dashboard
  3. Click a query to edit, for example Amount_1, then click Edit in the dropdown list.
    Select Edit in a step
  4. Click SAQL Mode to display the SAQL query.
    Click the SAQL Mode button
  5. View the SAQL query.
    Here is the SAQL query for our example:
    1q = load "DTC_Opportunity_SAMPLE";
2q = filter q by 'Closed' == "false";
3q = group q by all;
4q = foreach q generate sum('Amount') as 'sum_Amount';
5q = limit q 2000;
  6. Edit the query, then click Run Query to run the new query. For example, you could change the sum to average.