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.](a link)

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:

SettingEffect
Layer NameName of your current layer in the legend
CharttypeChoose a type of visualization for your layer
XColumn used for the X-Axis
YColumn used for the Y-Axis
Split byColumn to be used for a data split. Similar to GROUP BY
Sort byChoose a column and direction to sort your data
Filter byChoose a column, an operator and a value to filter your data

Styles

Choose a title, X, and Y axis labels.