Run a SQL query against PostgreSQL, MySQL, SQL Server, SQLite or another connected SQL database, or a MongoDB query or aggregation pipeline, then click Create Chart. Drop fields onto Group by, Measure and Color, pick from 20+ chart types, and watch the preview update as you go.
The everyday charts sit one click away under Show me: bar, line, area, pie, donut, treemap, funnel, heatmap, gauge and table. A chart your current fields can't draw is greyed out, so you only pick ones that work. More types lists the rest (scatter, bubble, radar, sunburst, Sankey, maps, calendar, timeline, candlestick, pivot and tree tables) along with the fields each one needs. The preview updates live as you change fields, colors and labels.
Pick fields instead of writing a query. Click a field from your MongoDB documents or SQL result, or drag it onto Group by, Measure, Color or Filters: group orders by channel, sum their totals, split each bar by status and keep only delivered orders. MongoDB charts are grouped in the database, so the totals cover every matching document, not a sample. Chart types the boxes can't hold yet, such as scatter, maps or Sankey, open a field mapping panel where Auto Detect suggests a starting point.
Every chart is backed by a MongoDB query, a MongoDB aggregation pipeline or a SQL query. Edit Query, Edit Aggregation or Edit SQL reopens the source so you can change filters, stages, joins or grouping, and the chart refreshes with the new data. For SQL charts you can also point the same query at a different connection, such as dev, staging or prod.
Run a SELECT and click Create Chart: the result's columns become fields you drop onto Group by, Measure and Color. Edit SQL opens the chart's query in the SQL editor right beside it, so you can change it, run it and Save to Chart. Anything your database dialect allows can feed a chart, including JOINs, GROUP BY, window functions and CTEs. The same steps work on PostgreSQL, MySQL, SQL Server and SQLite; only the SQL dialect changes.
A bar chart of revenue by country can come from a SQL table or a MongoDB collection. Once the result is loaded, mapping, styling and saving work the same way.
Run it in a SQL Query activity, then click Create Chart. Click country to group by it and revenue to measure it, and pick Bar under Show me.
Build the pipeline in the aggregation builder, then click Create Chart to send its output to the Chart Builder.
This walkthrough follows the PostgreSQL example from the Chart Builder documentation.
reports/sales in the chart library.Transform and prepare your data before visualizing it. Use aggregation pipelines to group, filter, and calculate metrics, then feed the results directly into Chart Builder to create powerful data visualizations.
Build the data queries that power your charts without writing code. Use Visual Query Builder to filter and select exactly the data you need, then visualize the results instantly in Chart Builder.
Check out the documentation to explore all the details about the Chart Builder and discover more VisuaLeaf features.
Read the DocumentationGet started free with our Community Edition. Includes a 14-day trial of Pro features.