Query Language

Custom query mode supports two query types in the UI:

• Single Query: one dataset for one panel
• Query Graph: multiple datasets combined in one panel

Both run on your organization’s analytics data and support live preview before saving.

Single Query (Best for Most Panels)

Use single query when you need:

• one time range
• one set of dimensions/measures
• straightforward filtering and sorting

Typical examples:

• daily clicks by date
• spend by platform
• conversion table for last 30 days

Query Graph (Best for Comparisons)

Use query graph when you want:

• 7d vs 30d comparisons
• channel A vs channel B in one chart
• derived values like delta or ratio

Common formula example:

• delta_clicks = clicks_7d - clicks_30d

Available Time Ranges

• 7d, 14d, 30d, 90d, 180d, 365d
• Custom date range (Enterprise query mode)

Filters You Can Use

• equals / not equals
• in / not in
• greater / lower than
• between

Usage Tips

• Keep measure count focused per panel.
• Use aliases for cleaner chart legends.
• In comparison queries, start with the broader dataset first.

Good to Know

• Custom query mode is available on the Enterprise plan.
• Query limits are in place to keep dashboards fast and stable.