Analytics SAQL Reference

Overview
Introduction
Use SAQL in the Analytics Dashboard
Enable SAQL Logs in the Browser
Quick Start
Examples
SAQL Basic Elements
SAQL Operators
SAQL Statements
SAQL Functions
Query Performance
PDF

Newer Version Available

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

Use SAQL in the Analytics Dashboard

Use the Analytics 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 Einstein Analytics 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 Analytics Studio, then open a dashboard. For example, open Opportunity Details.
  2. Click Edit.
    Click Edit on a sample dashboard
  3. Click a step 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 for the step.
    Click the SAQL Mode button
  5. View the SAQL query for the step.
    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.