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.

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

In particular, we will cover:

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.