Advertisement
Debugging Queries
Use the Query Editor and step-through execution to find why a chart is returning unexpected results.
Debugging Queries
Open the Query Editor
From any widget, Edit query opens the raw SAQL alongside a live results table — edit a line and rerun to see the effect immediately.
Step through the pipeline
Because SAQL is a sequence of reassignments to q, you can comment out later lines and rerun to see the data at any intermediate stage — a fast way to isolate which filter or group step introduced the problem.
Common mistakes
- Filtering after grouping when you meant to filter before — changes what gets aggregated.
- Comparing a date field without its derived suffix (
_Year,_Month) instead of the exploded field. - Forgetting
ason a generated field, leaving it with an auto-generated name the chart can't bind to.
What you'll learn next
With SAQL covered, the Bindings section shows how dashboard widgets pass values to each other and to queries at runtime.
Advertisement
Functions & Aggregates
The aggregate, string, and date functions you'll reach for most often when writing foreach ... generate clauses.
SAQL Queries
Learn the basics of SAQL — the Salesforce Analytics Query Language — to load, filter, group, and aggregate your data.
Advertisement
Advertisement