Series and layers define how SQL query results become visual chart elements.
Series
A series is a named set of values in a chart. In a bar chart, each series may become a group, stack, or line. In a line chart, each series becomes a line. In a radar chart, each series can become a separate polygon across the same radial dimensions.
Layers
Layers map query fields to chart roles such as x-axis, y-axis, value, label, or category. The exact layer behavior depends on chart type.
Why series and layers matter
They control:
- Which query columns are visualized
- How multiple metrics appear together
- Which series use which colors
- Whether a bar chart includes line series
- How chart legends and tooltips read
Tips
- Use readable SQL aliases.
- Keep series names short.
- Use consistent colors for recurring series.
- Remove unused fields from SQL results.