barbmk 
Personally, I believe that the configuration options for report pages in Looker Studio are often overlooked. Perhaps it’s because many of these features are relatively new. We’ll explore them in this post, and I’ll end with a trick I’ve used numerous times to replicate report pages more quickly. In this post, we will use data … Read more
This post is a bit different from the others. This time, we won’t dive into Looker Studio itself, but rather review something that can greatly simplify our lives when creating fields within the tool: regular expressions. They are so important that I think it’s essential to understand what they are and see examples before we … Read more
Sometimes, our metrics in Looker Studio don’t have the data type or aggregation we want. In this post, I’ll explain how to modify both. For the examples here, I’ll use the Superstore Products dataset. 1. Changing the Data Type When creating a metric, it defaults to a number. In the examples where we created new … Read more
Sometimes, even though your dataset has many fields, it may lack one you need. In these cases, you should assess whether it can be derived from the available fields and, if so, create it. This is the first blog post on custom fields, and we’ll focus on creating metrics. I’ll walk you through some examples … Read more
Blended data sources, or blends, are data sources where information from two or more different datasets is merged into a single dataset. Data sources are the core of your reports, and without them, no visualisation would be possible. A few years ago, Looker Studio (then Data Studio) began offering blended data sources, referred to as … Read more
In this post, I discuss two of the most common problems when creating blends in Looker Studio. If you want to read more about what blends or blended data sources are in Looker Studio, visit the post dedicated to this topic. 1. Duplicate Rows You may have noticed that at the end of each example … Read more
Waterfall charts in Looker Studio are excellent for understanding the sequential impact of positive and negative values relative to a baseline. We will use the Superstore Products dataset to see how net revenue has evolved over the years for the ecommerce in our data. Visit the post on how to add charts to your report … Read more
The treemap chart in Looker Studio is a mosaic with colored blocks inside. These are ideal for visualising data hierarchies, easily revealing patterns in large datasets. Personally, I love using this chart to visually represent hierarchy within a category. In this post, we’ll continue using the Spotify dataset and use it to display the songs … Read more
The Sankey diagram shows how a dimension is distributed and flows, tracing multiple paths indicating where the data is moving. The thickness of these links represents the weight of the relationship, based on the selected metric. In this post, we’ll look at an example using the Sankey diagram and explore its configuration options. Remember, visit … Read more
The scatter plot is ideal for analysing the relationship between two variables. In this post, we’ll explore how to set up this visualisation and what configuration options it offers. Remember, visit the post on how to add charts to your report in Looker Studio, if you need a refresher. 1. Example In this example, we’ll … Read more