2.8. Combo Charts: Combine Series for Dual Impact - Looker Studio Masterclass - Google Data Tutorial

Siavash Kanani (Ahmad)
Siavash Kanani (Ahmad)
6 هزار بار بازدید - پارسال - In this lesson, I'm going
In this lesson, I'm going to show you the difference between line charts and time series charts, and why using the right one matters. I'll reveal the potential danger of misusing line charts, as they can suggest a relationship and continuity between values that may not actually exist. By understanding these differences, you'll be able to make more accurate and meaningful data visualizations.

You'll see how line charts can sometimes lead to incorrect conclusions and how to avoid those pitfalls. By the end of this video, you'll know when to use a line chart, when to use a time series chart, and how to correctly interpret the data they represent.

00:00 Introduction
00:13 Metric Representation Options
00:25 When to Use Combo Charts
00:42 Appropriate Y-Axis Plotting
00:49 Revenue and Transactions Metrics
00:54 Use of Logarithmic Scale
01:13 Revenue Representation Per Country
01:52 Line Charts Vs. Bar Charts

---

- Learn the difference between line charts and time series charts
- Understand the dangers of using line charts incorrectly
- Know when to use each type of chart
- Avoid common pitfalls and misinterpretations of data
- Create accurate and meaningful data visualizations

💬 http://lookerstudio.community → To get help with Looker Studio.
📩 http://lookerstudio.tips → To receive my Looker Studio tips & updates newsletter.
🔔 Subscribe and turn on notifications so you don't miss the future lessons!

Looker Studio Certification:
When you're ready, take the final exam to test your knowledge and become a certified Looker Studio Expert →
https://lookerstudiomasterclass.com/l...

In this lesson we will learn how to visualize multiple metrics using line and bar charts in one Combo Chart. This is specially useful when visualizing related metrics (e.g., users and sessions) which we want to compare beside each other.

2.8. Combo Charts in Looker Studio

-- Introducing Combo Charts

Combo charts allow you to display multiple metrics in a single visualization, using different chart types (lines or bars) and different y-axes. These charts can be particularly useful when you have related metrics with distinct value ranges that you want to display together.

-- Setting up Combo Charts

To create a combo chart, simply add the desired metrics and select how you want each to be represented (line or bar). You can also choose whether to plot each metric against the left y-axis or the right y-axis, depending on their value ranges.

Example: Suppose you want to compare users and sessions, which have similar value ranges, alongside revenue, which has a very different range. You could plot users and sessions against the left y-axis, while plotting revenue against the right y-axis.

-- Using Log Scale

When dealing with diverse numbers, you can use a log scale to improve the chart's readability. In the example above, without a log scale, the revenue might drop sharply between countries, making the chart difficult to interpret. By applying a log scale, you can create a more visually appealing and informative chart.

-- Choosing the Right Chart Type

Combo charts are a more appropriate choice than line charts when dealing with categorical x-values, such as country names. While line charts can be useful for displaying trends or relationships between numeric categories (e.g., buckets of 10, 20, 30, 40), they may not accurately represent relationships between categorical values.

Combo charts in Looker Studio are great for visualizing multiple related metrics with distinct value ranges. By carefully selecting the appropriate chart types and y-axes, you can create informative and visually appealing charts that help you analyze and understand your data.
پارسال در تاریخ 1401/11/29 منتشر شده است.
6,051 بـار بازدید شده
... بیشتر