Graph View #

SELECT can visualize query results as charts. After running a query, switch to the graph view to plot your data.

Chart types #

Three chart types are available:

• Bar with optional stacking
• Line with data point markers
• Area with optional stacking

Configuration #

The graph panel lets you configure:

• X column: the column used for the horizontal axis
• Y columns: one or more columns for values (multiple columns create multi-series charts)
• Series column: pivot mode, where distinct values in this column become separate series
• Stacked: stack bar or area series on top of each other
• Legend: show or hide the series legend

Pivot mode #

When a series column is set, SELECT pivots the data automatically. Given a table with columns date, country, revenue, setting X to date, Y to revenue, and series to country produces one line per country.

Example: revenue by product category #

Combine pivot mode with runtime variables to build reusable report queries. This query uses $PERIOD and $MIN_REVENUE as runtime variables, so you can adjust the report without editing SQL:

SELECT
  date_trunc('week', o.created_at)::date AS week,
  p.category,
  SUM(o.amount) AS revenue
FROM orders o
JOIN products p ON p.id = o.product_id
WHERE o.created_at >= NOW() - $PERIOD::interval
GROUP BY week, p.category
HAVING SUM(o.amount) >= $MIN_REVENUE
ORDER BY week;

Set $PERIOD to 3 months and $MIN_REVENUE to 1000. Then configure the graph:

• Chart type: Area (stacked)
• X column: week
• Y column: revenue
• Series column: category

Each product category becomes its own stacked area. Change $PERIOD to 1 year and re-run to zoom out, or swap the series column to region for a geographic breakdown. The same SQL file becomes multiple reports depending on the runtime values.

Interactivity #

• Hover any data point to see a tooltip with values across all series
• Click a series in the legend to hide or show it
• Markers (dots) are shown for datasets with 200 rows or fewer

Limits #

When data exceeds these limits, a truncation notice is shown.