Visualizing Data

Thorntale can pull and chart data directly from your database, or from a public or shared Google Sheet. For now, let’s create a chart using a Google Sheet.

Connecting to a Google Sheet

Create a plain page. We’ll add a Chart to this page using the /chart command.

Choose the Google Sheets option. Give this source a name and paste the URL of the Google Sheet you’d like to query. You can use your own data, or the sample sheet below.

https://docs.google.com/spreadsheets/d/18bfGYl6axr4gS6ic6TAKxeGfGL5D_xgrXwLRKZhuGIY/edit#gid=0

If you use your own data, be sure to give view access to the Google Sheet with access@thorntale.iam.gserviceaccount.com.

Note

We expect the first selected row of your Google Sheet to be a header column, and will use the values in that first row as column names.

We also expect that all the values in a given column are of the same type (excluding the header row), and will interpret all values in a column as strings if there is any ambiguity.

You can use the Advanced tab in the Source Panel to select a certain range to query, like A3:C16, if you don’t need all the data in the sheet.

Building a Bar Chart

Once the data loads, click the Looks Good! button.

The sample data has three columns:

• Cat Breed
• Average Weight
• Hypoallergenic?

Since these are categories, instead of a timeseries or similar, we’ll choose a Bar Chart to represent this data.

Set the x-axis to Breed and the y-axis to Average Weight. You can also group by whether or not a given breed is Hypoallergenic.

Feel free to play around with the axis labels, series labels, and other settings.

Tip

If you’d like to use Snowflake or Postgres as a datasource, check out the Add a Datasource guide.

I’m ready to show the world.

Great! Let’s present our findings.