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|7 Comments


  1. Alexander 2018-11-08 at 04:12 - Reply

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

    • Marc Soares 2018-11-08 at 15:17 - 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!

  2. Rachel 2018-11-29 at 15:03 - 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 2018-12-21 at 09:14 - Reply

    Thank you for sharing your knowledge, Marc.

  4. Ryan 2020-03-29 at 13:57 - Reply

    If you wanted to look at the percentage total for each month, and use data for 12 months, is there a way to show percent of total for each channel for each specific month? When I do it, it compares each channel’s percent of total sessions for the entire year

    • Marc Soares 2020-04-06 at 16:10 - Reply

      Hi Ryan,

      Unfortunately, there’s isn’t a way to customize the built-in percent of total calculation yet. It will calculate based on the total of everything in the chart. Your best alternative right now would be to export your data into Google Sheets and calculate the percentages there, then connect to Data Studio.


Leave A Comment