This article explains how BlazeSQL visualizes query results as graphs and how you can customize them using the graph editor.
Automatic graph visualisation
BlazeSQL automatically displays query results in a graph format. If your results appear as a standard table, you can simply instruct BlazeSQL to "create a graph."
Supported Graph Types
BlazeSQL supports the following visualization types:
Table
Single Value
Bar Chart
Line Chart
Pie Chart
Scatter Plot
Map (for geographic data)
Edit Graphs
Open graph editor
Click the 3 dot menu icon in top right corner of a graph, and then click "Open editor".
Advanced graph features
Multi-bar & Multi-line charts
To create a Multi line or Multi bar chart, use the "Group by" variable. Each group will have a separate bar or line.
When making the chatbot request, just tell the chatbot which variable to group by. Ex. "get the number of users for each country, grouped by gender"
Interactive filters/sliders
To make your graph more interactive with a slider that filters the data in the graph, select a variable for the "Interactive slider" setting in the graph editor
Advanced bar chart settings
To change the order of bars in a bar chart, or change the axes to make bars horizontal:
Scroll down in the right pane of the graph editor and click "More".
Scroll down and configure the advanced settings as required
