Overview of Interactive Filters in Google Data Studio.
Google data studio and interactive filters on cxl institute.
The Journey with “Digital Analytics Minidegree” on CXL Institute is Continue and this is 5th Post.
this Minidegree will help you to learn Practical about Google Analytics, Google Tag Manager, Google Data Studio, BigQuery, and more so let’s learn Something:
How chart interaction filters work
Chart interaction filters add an identical way as to filter controls. as an example, a chart supported the Country dimension allows you to filter your report within the same way as a filter control supported the Country dimension. Brushing a statistic acts within the same way as a date range control.
Chart interaction filters may be restricted to groups, rather like filter controls.
Adding A Time Series Chart
Add a Time-Series Chart towards the underside of Page 2 as shown below.
We want to seem at the whole Quantities sold per month.
Remove the primary filter control “Quantity”
Click on the new statistic Chart and configure as follows:
Dimension: Order Date
Metric: Quantity (Change Name to Order Quantity)
Next, we modify the granularity of the X-axis (Time) from Day to Month. Click on the Pencil icon at “Order Date” under Dimension. Rename it to “Order Month”
Check “Show Axis Title” for both Y- and X-axis. you must be getting a Report that appears like this.
Filter Controls — Giving Viewers the flexibility to Filter
The above filters are editor controlled. this implies the viewers cannot filtrate what they require to determine. But if you wish your viewers to own control over what they see, then you’ll be able to use the filter control option within the Top menu.
Here, the filter is on the dimension — ‘Country’. therefore the viewers can select which countries they require to specialize in within the report. you’ll select which dimension you wish your viewers to play with once you create the filter using the information panel. this can be how it’s on the ‘View’ side.
You can change the fashion of the filter control by clicking on the filter control box and modifying it within the STYLE panel. for instance, you’ve got seen how an inventory appears once you apply filter control. But you’ll be able to also use a special format, where the viewer can explore for the worth. you’ll do that by clicking on the Search symbol.
This is how your viewers can filter on the report.
They can even select a bunch of values using the IN match type.
A lot more may be finished the match type- Regular Expressions, which may be a separate subject on its own.
Turning Table Charts Into An Interactive Filter
We are visiting add now the 2nd chart and switch this chart into a filter.
Insert a Table with Heatmap Chart to the Canva, just above the Time-Series Chart.
Dimension: Item
Metric: Transaction ID (Change name to Number of Orders)
Check “Show Summary Row”. the full number of orders should add up to 3000.
How Did We Derive At the number of Orders Received?
Choosing the Count of Transaction ID becomes the proxy for measuring the number of orders received.
Next, we wish to determine the Max. Min. and Average Quantity Sold by Items.
Add “Quantity” because of the second metric to the Table with Heatmap.
Click on the Pencil icon and choose “Min”. Rename to Min Qty Ordered.
Do the identical for the subsequent two metrics
Max Qty Ordered and
Avg Qty Ordered
I find that the Table with Heatmap is just too colorful on behalf of me. Let’s make the change here. Look under “Style” and amend the colors.
Adding Interactive to Chart
Click on the Table again. This time, under Data, check “Apply Filter” under Interactions. Toggle to look at mode.
Click “Bed” within the Table Chart. See the change being effected in the statistic Chart below.
Play around with the assorted Filter Controls on this Page. Before we leave this text, allow us to add yet another chart which is that the Geo Map.
You will notice that Google Data Studio automatically added “Deliver To” to the Dimension. Change the Metric to “Transaction ID”. Similarly, configure it to indicate “Count” and rename to “Number of Orders”.
Do you remember the way to turn this Geo Map into an Interactive Filter?
In View mode, click on both this Geo Map and also the Table Chart to determine the changes to the statistic Chart.
Chart Filters
This one is my favorite! instead of selecting or searching, you’ll let your viewers directly interact along with your charts within the report.
Create all the charts you would like from your data. Now click on the chart you would like your viewers to be able to interact with to filter. Search for ‘Interactions’ at the underside of the information panel and choose ‘Apply filter’. do that to any or all the charts you wish your users to be able to use as filters.
Check out what happens on the ‘View’ side of things.
You can select a rustic and every one of three of the charts modifies their contents filtering all the way down to just that country. (That is, the three charts interact with one another.)
You can next also click on the age bracket that you simply have an interest in to filter it all the way down to a particular age bracket.
You can apply the filters on multiple charts without delay or on only 1 chart.
Drill Down
Another way of letting the viewer control the charts directly is that the ‘Drill down’ within the DATA panel.
Click on any chart and switch on the Drill down toggle within the DATA panel.
Go on view and check the results. during this case, I’ve got enabled Drill down on the map chart. you’ll be able to apply it to any chart.
By clicking on the Up or Down symbols on the map, I can move up or down within the level of details on the chart. as an example, in an exceedingly GeoMap, the city/country would be rock bottom level. Next comes the subcontinent then finally the continent. you’ll adjust the hierarchy within the DATA panel within the Drill down section.
Note that this relies entirely on the chart you decide on and also the data you have got. as an example, if you’re coping with Date, you’ll probably have Day, Month, and Year. If it’s a product that you simply are staring at in your sales report, it would be SKU, Category, Department, etc.
Check out what happens as you begin from a lower level to a better level by clicking on the Up arrow within the GeoMap.
Click on the Up button at the top-right of the map and click on some region on the map.
Go another level up and check out clicking on a district.
Metric Slider
Another way to manage what you view within the chart is thru the ‘Metric slider’. Enable metric slider on a chart and you’ll be able to use the slider to look at values within the selected range.
Thanks, CXL.
Let’s Dive in the Resources:
Working with Google Data Studio Filter: A Detailed Guide.
Using Charts as Interactive Filters in Google Data Studio.
