The area chart in Looker Studio

The area chart is used to represent quantitative values over time, helping you detect trends and volumes. It is similar to time series charts, but this one requires the selection of a breakdown dimension. In other words, apart from the time dimension, we will have one more. Imagine that you have an ecommerce business, and … Read more

Time series in Looker Studio

Time series charts are perfect for observing how your metrics evolve over time. For these examples, I will keep using the dataset of top movies from 2019. You can visit the post on how to add charts to your report in Looker Studio, if you need a refresher. 1. Example To see a time series … Read more

Pivot tables in Looker Studio

Like regular tables, pivot tables are used to display data in more detail. However, they have the added advantage of allowing you to analyse data by crossing multiple dimensions simultaneously. In this post, we will continue using the dataset of top 2019 movies. 1. Example Imagine that you want to see the number of movies … Read more

Gauge with ranges in Looker Studio

Just like scorecards and bullet charts, gauge with ranges are used in Looker Studio to represent your most important Key Performance Indicators (KPIs). Additionally, these allow you to display the value of your metric with ranges, as well as alongside a target. 1. Example We will use the same example as we did with the … Read more

How to create dimensions with calculated fields in Looker Studio

We have seen how to create calculated fields in Looker Studio and focused on metrics. This was to make it easier to understand by starting with them. Now we will do the same with dimensions. As a reminder, the difference between a dimension and a metric is that the former are categories (country, product type, … Read more

The bullet chart in Looker Studio

Like the scorecard, the bullet chart in Looker Studio is often used for your most important metrics or Key Performance Indicators (KPIs). The advantage of bullet charts is that they provide context to the metric being analysed by displaying alongside the target or benchmark in the form of a horizontal bar. In this post, I … Read more

How to add charts to a report in Looker Studio

Eager to start exploring the available charts in Looker Studio? After reviewing the tool’s interface and how to add data sources, now we’ll dive into how we can visualise that data. In this post, I’ll focus on explaining how to add visualisations and briefly mention the configuration and style options. Each chart has a dedicated … Read more

Looker Studio scorecards

The scorecard is one of the most commonly used charts in Looker Studio. It is often used to monitor the most important metrics or Key Performance Indicators (KPIs). In this post, I’m going to walk through an example using dara from the top movies 2019 to show the configuration options this visualisation offers. Follow the … Read more