Announcing our $3.4M seed round from Gradient Ventures, FundersClub, and Y Combinator 🚀 Read more →
How to Make Charts to Visualize Your Data
After you run a query, look for the Chart
button to create a chart.
Line chart
Let's look at how many questions are asked per day on StackOverflow:
select *
from `bigquery-public-data.stackoverflow.posts_questions`
where creation_date between '2020-01-01' and '2020-01-31'
If we wanted to see two series, one for answered questions, and another for unanswered questions, we need an answered
boolean column:
select
*,
answer_count > 0 as answered
from `bigquery-public-data.stackoverflow.posts_questions`
where creation_date between '2020-01-01' and '2020-01-31'
Here's a video tutorial showing how to create a line chart:
Bar chart
Let's look at the top 10 most popular tags on StackOverflow and make a bar chart.
select *
from `bigquery-public-data.stackoverflow.tags`
order by count desc
limit 10
Pie chart
Using the results from the previous pie chart example, here's what it would look like if we changed the chart type to a pie chart:

Spread the word
Tweet