Calculating Percent of Total in Data Studio

Calculating Percent of Total in Data Studio

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:

  1. In your data source, ensure that Field Editing in Reports is enabled:
  2. 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:
  3. Hover over the data type icon on the left-hand side of the field and click the pencil icon:
  4. 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”:
  5. 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:

Check out our upcoming in-class Data Studio course to learn more about community connectors, visualization techniques, and more!

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

By |2017-12-18T15:00:38-05:00December 13th, 2017|5 Comments

5 Comments

  1. Alexander November 8, 2018 at 4:12 am - Reply

    Do you know how to pull the organic search % into a scoreboard?

    • Marc Soares November 8, 2018 at 3:17 pm - Reply

      Hi Alexander,

      You can accomplish this by making use of data blending and a chart-specific calculated field:
      1) Create one scorecard with total Sessions.
      2) Create a second scorecard with Sessions and apply the Organic Traffic segment.
      3) Blend the two scorecards (Select both charts > Right click > Blend data)
      4) In the blended chart, create a calculated field: Organic Sessions / Total Sessions; and change type to Percent.

      Hope that helps!
      Marc

  2. Rachel November 29, 2018 at 3:03 pm - Reply

    I’m not seeing how you can create a calculated field in a blended data source. Am I missing something?

  3. Alexander Langholm Skogvik December 21, 2018 at 9:14 am - Reply

    Thank you for sharing your knowledge, Marc.

Leave A Comment