How to build interactive graphs in Google Data Studio
2 min readJan 3, 2020
Why?
- Interactive graphs let you to filter other graphs in same page by clicking on one unit on a specific graph.
i.e. First graph shows your monthly revenues and second one shows revenues by country. With interactive graphs, when you click on bar for October in first graph, countries in second graph will show revenues only for October.
- Eventually it lets you to play around graphs very practically and to go deeper about numbers by just clicking on correct units.
- Similar with first example, you could first click on specific country, then first graph would show monthly revenues for that country only.
How?
- Let’s say we want to have 3 graphs which will give scoring insights about England Premier League:
a. Monthly total goals
b. Total goals by team
c. Total goals by player - Whole data must be in one table. And in each row you have to include 3 variables at the same time. Example:
- Now connect your spreadsheet as a data source to your google data studio dashboard, and add 3 bar charts (as an example) for each variable: Month, Team, Player. Example below is for players:
- For other 2 graphs, you just need to change Dimension, by keeping metric as a Goal.
- Then for each graph you need to enable Apply Filter option:
- Now just click on bars at your each graph and enjoy your interactive filtering.
- Here is the working example for you: https://datastudio.google.com/reporting/fbdf9ce4-80fe-407b-8c55-da502b3517db/page/Jo58
Looking for a productivity tool? Notion.so has everything you need:
https://affiliate.notion.so/sz2vffjwc8hp