How to Fix N/A, Null, 0... in Looker Studio

preview_player
Показать описание
Missing values like the famous “Null” or “NA” are not the prettiest thing to see on your charts. But simply removing them may have a significant impact on your analysis. In this tutorial, we'll explore safe methods to handle missing values in Looker Studio and share tips to avoid any traps.

📚📚 Courses and Resources ⏬⏬

👍 FOLLOW US 👍

OUTLINE:

00:00 - Introduction
00:59 - Identifying Missing Values
02:32 - When to Keep/Remove Missing Values
03:27 - Using Filters to Remove Null Values
04:08 - Adding a Control to Remove Null Values
08:46 - Null Values Data Types
10:14 - Conclusion
Рекомендации по теме
Комментарии
Автор

Hello MeasureSchool Team.

I'm getting Null value despite having data on those cells.
I'm currently working on a 2024 version of a 2023 report I used. I'm getting null only for the percentage values, even though they're set as the same values from the 2023 report. The numbers are being read normally.

Am I missing something? Apart from reconnecting the table, and updating the value format, what else could I do?

Littlestress