How to group data in looker studio ?

How to group data in looker studio ?

How to group data in Looker Studio?

Looker Studio recently added a new feature to create a custom group without writing any line of code. You can visually set custom labels on dimension values matching a specific condition. It can be helpful to group countries or campaign matching sets of conditions.

Here, we will show you how to use the features.

How do you create a custom group in Looker Studio?

From your report in edition mode, select a chart. In the Set-up column, add a new dimension and click on Add group.

Add a new Group in your Looker Studio report.

Then follow these steps:

  • In "Select field to group", select the field to use. You can choose a dimension or a metric; the conditions sets will adapt accordingly.
  • Name the new field that will be created.
  • Select the first Group name and set up the condition. Here
  • Add a new group if necessary.
  • Define a default value for all rows that do not match any conditions.

Here's a generic example:

I have a Country (Pays in the following screenshot) field, and I want to group them by continent; here's what I need to do.

Example of a new Group that extract Country from Campaign name in Looker Studio

More function to use with Looker Studio

WEEK
:
Analyzing and Presenting Your Data by Week: The Essential Guide to Using the WEEK Function in Looker Studio
CURRENT_DATETIME
:
Taking advantage of the CURRENT_DATETIME function in Looker Studio
LOWER
:
Mastering the LOWER Function in Looker Studio: Enhancing Data Consistency and Accuracy in Data Analytics
LENGTH
:
Understanding the LENGTH Function in Looker Studio: A Comprehensive Guide to Counting Characters
DATE_FROM_UNIX_DATE
:
Decoding Date Data: Understanding and Applying the DATE_FROM_UNIX_DATE Function in Looker Studio

Need a clearer view of your data?

Find +50 free templates for Facebook, Instagram, Google Ads and more!

Get it for free