Charts

The shortcut to create an SQL Block is [&&&] + [spacebar].

Chartypes currently available:

  • Bar
  • Line
  • Area
  • Pie
  • Scatter

Click the EDIT button to open the chart editor.

Chart Editor

View this chart and data here.

Setup

Charts consist of layers that reference queries for data. A chart can have any amount of layers of mixed visualization styles.

Each layer has to be adjusted separately:

Setting Effect
Layer Name Name of your current layer in the legend
Charttype Choose a type of visualization for your layer
X Column used for the X-Axis
Y Column used for the Y-Axis
Split by Column to be used for a data split. Similar to GROUP BY
Sort by Choose a column and direction to sort your data
Filter by Choose a column, an operator and a value to filter your data

Styles

Choose a title, X, and Y axis labels.

Jump to