University > Looker Studio Course > How to > How to group data in looker studio ?

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

REGEXP_CONTAINS

:

Understanding and Utilizing the REGEXP_CONTAINS Function in Looker Studio for Data Manipulation and Extraction

:

Mastering the MEDIAN Function in Looker Studio: A Comprehensive Guide to Syntax, Use Cases, and Limitations

:

Understanding and Leveraging the DATETIME_DIFF Function in Looker Studio for Efficient Data Analysis and Visualization

:

Understanding the DATETIME Function in Looker Studio: Syntax, Functionality, and Essential Tips

:

Utilizing the NARY_MAX Function in Looker Studio: A Comprehensive Guide to Enhancing Data Analysis Efficiency

Become a Looker Studio expert
for free

Learn all the secrets of data analysis and create beautiful and effective dashboards thanks to our 30-second video courses! Join Catchr's community on YouTube.

Get more video lessons

All your data on Looker Studio

Build Looker Studio dashboard easily with your marketing data from all platforms and track your essential KPIs! No-code integration.

Start free trial now!

Looker studio

Optimize your data analysis

Get free Looker Studio dashboard template among a large collection of +50 stunning template! Elevate your data visualization.

Get free templates!

Johan Chemin

Customer Success Manager & Looker Studio Expert

I design powerful dashboards that enable you to effectively analyze your marketing data. I also provide comprehensive lessons on mastering your BI tools. Feel free to contact me for assistance with these areas.