Chart

A chart aggregates and processes SQL run results, then renders them as a graph or table. You can use charts on doc pages and grid pages.

Charts are rendered in the following flow.

1. Fetches the run results of the SQL specified as the data source.
2. Processes the data based on the chart's basic settings (dimensions, metrics, source filter, and so on).
3. Processes the data in-memory if the conditions are met, or with SQL otherwise.
4. Renders the chart based on the processed result (up to 1000 rows) and the advanced settings.

See Concepts for details.

Key features

• Concepts: how rendering works, data modeling, and in-memory processing
• Dimensions and metrics: units of aggregation and aggregation methods
• Filter, sort, and limit: source filter, sort, row limit, and the difference between group by and frame
• Common settings: frame, value formatting, reference lines, trends, statistics, and more
• Explorer: exploring data sources and adding charts
• Cross filter: linking charts on a grid page

Chart types

Type	Typical use
Big Number	A single indicator or gauge display using a metric and an optional secondary metric.
XY Chart	Aggregates a Y value (metric) against an X value (dimension). Line, bar, area, scatter, and more.
Radial Chart	Aggregates a value against a label. Pie, donut, and radar charts.
XYZ Chart	Aggregates a Z value (metric) against X and Y values (dimensions). Scatter, bubble, and heatmap.
Hierarchy Chart	Aggregates a value against a hierarchy (dimension). Tree, treemap, sunburst, and more.
Graph Chart	Aggregates a weight against source and target. Network and Sankey diagrams.
Funnel Chart	Aggregates a value against a label to visualize a step-by-step process.
Waterfall Chart	Shows the cumulative increase and decrease of a value against a label.
Table Chart	Displays data as a table, either as raw rows or aggregated.
Pivot Table	Cross-tabulates a value (metric) against rows and columns (dimensions).
Text Panel	Displays the first value of a selected column as text.
Map Chart	Visualizes geographic data using latitude/longitude, geohash, geocode, or GeoJSON.
Word Cloud	Aggregates a value against a word to visualize word weight.

Each page includes details on drawing types and settings.