How to Make Charts to Visualize Your Data
After you run a query, look for the
Chart button to create a 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:
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
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 wordTweet