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.
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.