Chart overview

Charts are your tool for visualizing data in Summer.

As described in our Query Overview, Charts are built directly into your Queries. Write a Query, run it, and you can start making Charts. Saving your Query will save any new Charts or changes to existing Charts.

Building a Chart

To build a Chart, start by choosing the Chart type. Our supported types are described below.

Once you select a Chart type, you will now need to pick the Chart’s data.

The Chart Builder is divided into two sections, Data and Format. Data is where you will map columns from your results to elements of the Chart. Format is where you will choose the visual style and labelling for your Chart.

Here are a few notes on some common settings,

• Vertical axis - You can click Add column + to choose multiple columns which will each map to individual elements (i.e. line, bar, pie slice).
• Category - If selected, creates an element (i.e. line, bar, pie slice) per unique value. If unselected and there are multiple Y values per X value, the Y values will be automatically summed per X value.
• Facet - If selected, creates an individual chart per unique value. Charts are displayed vertically stacked.

Chart types

Line — Commonly used for displaying data over time

Bar — Horizontal and Vertical stacked bar charts are supported, as well as side-by-side Multi-bar charts, great for displaying categorical data

Scatter — Effective at comparing a combination of metrics (e.g. Revenue and Company Size)

Area — Stacked by default, also great for displaying categorical data

Pie — Used to show the proportions of the selected category as a whole

Table — Can choose all or a subset of the columns from your results, supports export to Parquet and CSV

Single Metric — Displays the value from the first row of the selected column, great for high level metrics

Managing Chart access

Charts inherit permissions from their Query. Please see Managing Query access for more info.