Guides
Charts
Turn query results into bar, line, area, pie, or scatter charts without leaving Dora.
Charts
Any result set in the SQL Console can be visualized as a chart. Run a query, then open the chart view from the results toolbar.
Build a chart
Dora suggests a sensible chart configuration from your result columns, which you can adjust:
- Chart type — bar, line, area, pie, or scatter.
- X axis — pick a category, date, or numeric column.
- Y axis — one or more numeric columns (add several series).
- Aggregation — sum, average, or count.
- Group by — an optional column for multi-series grouping.
The chart updates live as you change the configuration.
Some chart types have requirements: a pie chart uses a single Y column, and a scatter plot needs numeric X and Y columns. Line and area charts read best with a time or numeric X axis.
Write a query that returns exactly the shape you want to chart — for example a
GROUP BY with a count — and the result maps directly onto the axes. You can
export the rendered chart as a PNG image.