4.3. Understanding Aggregation in Looker Studio

Aggregation is a fundamental data modeling function in Looker Studio.

Aggregation is the act of reducing and summarizing data.

In this lesson we will discuss the built-in aggregation methods available in Looker Studio and how we can utilize them to better answer our report users’ questions.

Aggregation: Live Demo

Let’s see how aggregation works in Looker Studio using a sample data source.

In particular, we will cover:

• How aggregation works in a scorecard

• Different aggregation methods: Sum, Average, Minimum, Maximum, etc.

• How aggregation works for a dimension

Aggregation per Category

We will cover how aggregation by category works in this demo.

In addition, we will also discuss how the grand total field works differently in certain situations and when we apply aggregation by category.

We will also discuss why renaming an aggregated field is a simple but important task to do to prevent confusion or data miscommunication with report users