As an analyst, one of the most essential calculations that you likely perform on your data is a percent of total. What proportion of traffic is from mobile and tablet? What percentage of conversions can be attributed to AdWords campaigns? What share of revenue comes from returning customers? Questions like these can only be answered by calculating percentages.
Percentages are so common that tools like Google Analytics have them built-in. In most standard GA reports, the percent of total is automatically calculated and displayed in each row of the table. There are many situations where percentages will provide more meaning than the values themselves. In Google Data Studio, displaying a percent of total in your charts and tables can similarly enhance the effectiveness of your reports.
So, how can you get a percent of total in Data Studio? We’re glad you asked!
This post will show you how to use field editing and analytical functions to add “percent of total” metrics to your Data Studio reports.
Calculating Percent of Total in Data Studio:
- In your data source, ensure that Field Editing in Reports is enabled:
- In your report, create a chart and add the desired base metric. For example, if you wish to calculate the percent of total sessions, add Sessions:
- Hover over the data type icon on the left-hand side of the field and click the pencil icon:
- In the popup that appears, select “Percent of total” from the Analytical Function dropdown. Also, enter a name for your new percent of total metric, e.g. “Percent of Total Sessions”:
- If you wish to display the metric values along with the percent of total, click “Add a Metric” and select the original metric. Note that if you haven’t given your “percent of total” metric a unique name as shown above, you won’t be able to select the original metric again.
Adding a Percent of Total works well as a column in tables and in bar charts. Using data from the Google Merchandise Store, we have created a report below with some example use cases:
See related Data Studio posts below:
1. Tracking Your Data Studio Dashboards in Google Analytics
2. How to Share a Data Studio Report
3. Google Analytics Dashboard Template for Data Studio
4. Calculating Goal Flow Conversion Rate in Data Studio
5. Adding Images to Your Tables in Data Studio
6. Embedding Links in Data Studio
7. Simple Visualizations in Data Studio
8. Custom Channel Groupings in Data Studio
9. Tips for Using RegEx in Data Studio
10. Data Studio Connectors from a Galaxy Far, Far Away
11. Audit Your Google Analytics Implementation with Data Studio