How to Calculate Percentage in Looker Studio

Displaying data as a percentage is one of the most effective ways to add context to any report. Instead of just showing that you got 5,000 visitors from your newsletter, you can show that it accounted for 25% of all traffic, instantly highlighting its importance. This article will walk you through the primary methods for calculating and showing percentages in Google Looker Studio, from simple one-click operations to more powerful custom formulas.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Calculating Percentages is a Reporting Superpower

Before we jump into the "how," let's quickly cover the "why." Raw numbers can be hard to interpret. Is 1,200 sign-ups a lot? It depends. If it’s out of 2,000 visitors, that's an incredible 60% conversion rate. If it's out of 2,000,000 visitors, that's a dismal 0.06% rate. Percentages add that crucial layer of context, allowing you to quickly understand:

• Proportions and Contributions: What percentage of sales comes from each marketing channel?
• Performance Against Goals: What percentage of our quarterly sales target have we hit so far?
• Conversion Rates: What percentage of website visitors sign up for a trial?
• Change Over Time: What was the percentage increase or decrease in traffic this month compared to last?

Mastering these calculations will make your dashboards more insightful and easier for your audience to understand at a glance.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 1: The One-Click "Comparison Calculation"

For many common percentage calculations, like finding the percent of a total, Looker Studio has a built-in feature that requires zero formulas. This is the fastest and easiest way to get started.

This method works best for showing the proportion of a single metric across a dimension. Think of questions like, "What percentage of our total sessions does each country contribute?" or "What percentage of revenue comes from each product category?"

Let's use a simple table to show sessions by country as an example.

Step-by-Step Instructions:

1. Start with a Chart or Table. Create a new table chart and add your dimension (e.g., Country) and your metric (e.g., Sessions). You'll initially just see the raw session counts for each country.
2. Find the Metric to Modify. In the Setup panel on the right, find your metric under the "Metric" section.
3. Edit the Metric. Hover over the metric block (it will be a green block that says "Sessions") and click the small pencil icon that appears next to its name.
4. Choose a Comparison Calculation. In the pop-up window, click the dropdown menu under Comparison calculation. By default, it's set to "None." You'll see several options, but we'll focus on the most popular one.
5. Select "Percent of total." This option divides the value for each row by the grand total for the entire dataset in the chart. Your table will instantly update to show the percentage of total sessions for each country instead of the raw number. It even keeps the total at the bottom to show 100%.

That's it! In a few clicks, you’ve transformed a list of numbers into a clear relational analysis. This feature is also a quick and easy way to create a pie or a bar chart too.

Method 2: Using Custom Calculated Fields for Ultimate Flexibility

The "Comparison calculation" is great for simple cases, but often you'll need to calculate a percentage based on two different metrics. This is known as a rate or a ratio. Examples include:

• Conversion Rate: Transactions / Sessions
• Email Open Rate: Emails Opened / Emails Sent
• Profit Margin: (Revenue - Cost) / Revenue

For these scenarios, you'll need to create a calculated field and write a simple formula.

Example: Calculating a User Conversion Rate

Let's walk through building a "conversion rate" metric in a Google Analytics 4 data source. We want to calculate the percentage of total users who made a purchase. The GA4 metrics we need are Total Users and Conversions (assuming your primary conversion event is a purchase).

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step-by-Step Instructions:

1. Select a Chart. Create a scorecard or add a column to an existing table where you want to display your conversion rate.
2. Open the Field Creator. In the Setup panel, click on Add metric, then scroll to the bottom of the list and click CREATE FIELD.
3. Name Your New Field. At the top of the formula editor, give your new field a clear name, like "User Conversion Rate."
4. Write the Formula. In the Formula box, you'll divide your success metric (Conversions) by your total sample metric (Total Users). Because these metrics are already aggregated, you can simply type: Conversions / Total Users Look for the green checkmark below the formula box. This confirms your formula has valid syntax. If it’s red, double-check the names of your metrics for typos.
5. Set the Data Type (This is Critical!). In the bottom left, click the Type dropdown menu. By default, your new field will be a generic Number, which will show your conversion rate as a decimal (e.g., 0.042). To make it display correctly, navigate to Numeric > Percent.
6. Apply and View. Click the blue Apply button in the bottom right corner. Your new "User Conversion Rate" metric will be added to your chart and formatted correctly as a percentage.

You can use this same process for countless custom ratios specific to your business needs, like calculating cost per acquisition, return on ad spend, or task completion rates.

Method 3: Blending Data to Calculate Percentages Across Sources

What if your metrics don't live in the same place? This is a very common problem. For example, your website session data is in Google Analytics, but your sales data is in Shopify. To calculate your website's true e-commerce conversion rate (Shopify Sales / GA Sessions), you need to combine - or blend - these sources first.

Data blending merges two or more data sources based on a common key, like a date or campaign name.

Step-by-Step Overview:

1. Start the Blend. Add a chart to your report, and in the Setup panel, click Blend data under the Data source section.
2. Add Your Primary Data Source. This will be your "left" table. Let's say it's your Google Analytics 4 data. Add Date as your dimension (the join key) and Sessions as your metric.
3. Add Your Second Data Source. Click Join another table and add your Shopify data. Add Date as the dimension to match the first source, and add Total Sales as your metric.
4. Configure the Join. A join condition tells Looker Studio how to match rows from both tables. Choose Left outer as the join type and make sure Date is selected as the matching field for both tables. Save the blend.
5. Create the Calculated Field. Once the blend is created, you now have a new data source that contains both Sessions and Total Sales. Now, you can follow the exact same steps in Method 2 to create a calculated field with a formula like: SUM(Total Sales) / SUM(Sessions) Notice we use SUM() here. When working with blended data, it's a best practice to specify the aggregation (SUM, AVG, COUNT) to avoid errors. As always, remember to set the data type to Numeric > Percent.

Common Issues That Come Up When Working with Percentages

Working with formulas in Looker Studio can sometimes throw errors. Here are a couple of the most common issues you'll run into when calculating percentages and how to fix them.

Aggregation Errors

If you see an error like "Re-aggregating metrics is not supported" or "Invalid Formula," you're probably trying to mix an aggregated metric with an unaggregated one.

• The Problem: Formulas can't mix pre-calculated totals (like SUM(Sessions)) with a single row-level value (like Country).
• The Fix: Make sure every metric in your formula is wrapped in an aggregation function like SUM(), COUNT(), AVG(), or COUNT_DISTINCT(). For example, instead of Total Sales / Sessions, write SUM(Total Sales) / SUM(Sessions).

Even if it feels redundant, explicitly telling Looker Studio how to aggregate your metrics solves most formula-related errors.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Incorrect Formatting

This is the most common issue we see when using Looker Studio with calculated fields - it calculates the percentage as a decimal by default, which just isn't readable for most cases.

• The Problem: The result of your conversion rate says 0.05 instead of 5%.
• The Fix: You just forgot to update your field’s type to Numeric > Percent.

Final Thoughts

You now have three powerful methods for calculating percentages in Looker Studio. You can use the built-in comparison calculations for quick percent-of-total analysis, write custom formulas with calculated fields for specific ratios like conversion rates, and even blend data for a holistic view across different platforms. Using these techniques effectively will elevate your reports from simple data tables to compelling, context-rich dashboards.

Of course, mastering these data blends and formulas can still involve a lot of trial-and-error and clicking through menus. We created Graphed because we believe getting these insights shouldn't require manual report building. Instead of setting up data blends and writing formulas, you can simply ask, "What was our eCommerce conversion rate for Google Ads campaigns last month?" Graphed connects to your sources like Google Analytics and Shopify, understands the question, and instantly creates the visualization for you, correctly formatted and ready to share. It's a way to skip right to the answer, without getting stuck on the setup.