Space comes at a premium when designing a dashboard. The more you try to fit on a screen at once, the less effective your dashboard becomes at communicating key information. With a tool like Google Data Studio however, interactivity allows you to focus your dashboard on what’s most important, yet still allow your audience to further explore the data on their own.
Interactive filter controls can let your viewers compare different segments, like device types, channels, or countries. Date range selectors can allow for changing the report time period. And drill down can enable viewing charts at different levels of granularity.
In this post, we’ll cover one more way to build interactivity into your Data Studio reports: Optional metrics!
If you use Google Analytics, you are likely already familiar with the concept of optional metrics. Many standard charts in GA have a dropdown menu that allows you to change the metric displayed on the chart. In the same way, Data Studio allows you to provide additional “optional” metrics for your viewers to selectively display on your charts.
Let’s see how to enable optional metrics in Data Studio in a few simple steps:
How to Enable Optional Metrics in Data Studio
1. Select a chart
Add a chart or use an existing chart in your report. The optional metrics feature is currently available in all charts, except for scatter plots and pivot tables.
2. Turn on optional metrics
In the Data panel of the chart, there is an “Optional metrics” toggle below the list of selected metrics. Click the toggle to enable optional metrics for the chart.
3. Add optional metrics
Once you’ve enabled optional metrics, you will be able to add another set of metrics to the chart.
You can have a maximum of ten optional metrics per chart, however the number you can select depends on the chart type and number of required metrics already present in the chart.
Note that optional metrics will not be shown in the chart by default, but will be available in a dropdown menu. So, you should keep any key measures selected as required metrics. Optional metrics would be best used for metrics that are not critical, but “nice to have” for further exploration.
4. Using optional metrics as a viewer
In view mode, the optional metrics selector is available in the chart header. Click the optional metrics icon to open the selection menu. When using optional metrics, you may wish to set your chart headers to “Always Show” to make it more obvious to the viewer.
Depending on the chart type and configuration, the optional metrics menu will show as a list of either checkboxes or radio buttons.
When the chart configuration allows for multiple metrics, you can use the checkboxes to add and remove metrics from the chart. Otherwise, the radio buttons will let you switch from one metric to another. To return to the default chart setup, click the back arrow at the left of the chart header.
Here’s a sample dashboard demonstrating the use of optional metrics with different chart types:
Let us know how you use optional metrics in your Data Studio dashboards and reports!
Complete list of posts in our 2019 Data Studio series:
1. 5 More Calculated Fields for Data Studio
2. Using Drill-Down Charts in Data Studio
3. How to Schedule Email Delivery of Reports in Data Studio
4. 4 Scatterplot Hacks for Google Data Studio
5. How to Add Clickable Images in Data Studio
6. Calculating Ratios with Filtered Metrics in Data Studio
7. Using Optional Metrics in Data Studio
8. Using Conditional Formatting in Data Studio
9. Creating Ecommerce Funnels in Data Studio
10. How to Create a Slope Chart in Data Studio
11. Creating Radar Charts in Data Studio
12. Creating Stepped Line Charts in Data Studio