Query-to-chart analytics

Build a chart from a question, inspect the SQL, and keep the dashboard configurable

Dashboards connects visual query building, editable SQL, configurable charts, variables, refresh controls, and resizable layouts in one workspace.

Query paths: Visual builder or SQL
Chart setup: Type + fields + colors
Controls: Variables + refresh
Layout: Move + resize blocks

The interface preview uses illustrative data and disabled controls. Available charts, query results, refresh behavior, and collaboration options depend on configured connections, permissions, and deployment.

Illustrative interface

Dashboard chart

Completed-order revenue

Sample configuration - no live data connection or query execution

Query BuilderSQL

Visual query

Selection

public.orders

Read sample

date_trunc(month, created_at)SUM(total_amount)status = completed

Generated SQL

Builder output

READ ONLY

SELECT
  date_trunc('month', orders.created_at) AS month,
  SUM(orders.total_amount) AS revenue
FROM public.orders
WHERE orders.status = 'completed'
GROUP BY 1
ORDER BY 1 ASC
LIMIT 12;

Chart preview

Monthly completed-order revenue

Sample output

Chart preview

Monthly completed-order revenue

Sample output

Dashboards keeps the path from question to chart visible. Start with the visual builder or write SQL directly, configure the chart, then arrange the resulting blocks in a dashboard without separating the query from its presentation.

Build the query in the mode that fits the question

The visual builder lets you choose a source and table, select columns, add filters and joins, set sorting, and apply a row limit. Its state can generate SQL for inspection and editing. Use that path when the shape of the question is clearer than the final query text.

Switch to SQL when you need to write or revise the statement directly. The two paths are useful for different stages of the same investigation: assemble the first pass visually, inspect the generated SQL, and refine the query when the question calls for it.

Before adding a chart, check the source, fields, joins, filters, and limit. A chart can make a result easier to read, but it does not establish that the selected data or query logic is correct.

A working sequence

Define the question and select the connection, source, and table that can answer it.
Build or write the query, then inspect the fields, filters, joins, sorting, and row limit.
Configure the chart only after the result shape is suitable for the comparison.
Add the chart to a dashboard with the context a reviewer needs to interpret it.

Configure the chart with the fields in view

Choose a chart type, assign an X field and one or more Y fields, then set the title, legend, display settings, and colors. Map-oriented chart configurations also expose map fields when that configuration is relevant.

The interactive gallery below renders public World Bank data as bar, line, area, pie, radar, and scatter charts. It demonstrates renderer output separately from the disabled product-interface preview above; it is not a live product connection or a statement of current picker availability.

The application registry includes more renderers than the standard chart picker exposes. Available chart choices depend on the interface and deployment; do not assume every registered renderer is directly selectable from the standard picker.

Dashboards / rendering gallery

Six ways to read public records.

This rendering gallery pairs compact SVG charts with USA annual indicators and a 2023 comparison across the United States, Canada, Mexico, and Brazil. Color is paired with direct labels, legends, and focusable marks.

World Bank public indicators · USA 2015–2023 · 2023 country comparison

GDP (current US$), population (people), and life expectancy at birth (years).

Loading live World Bank data · bundled snapshot retrieved 2026-09-02