Remove null
Discover how to remove null values in Looker Studio for cleaner data analysis. Learn effective methods to manage and handle missing data efficiently.
How to
How to remove null in looker studio ?
Sometimes in Looker Studio, some metrics displays Null in a charts instead of a zero. But this can be avoid and you can choose what to display between a range of choice.
We will cover it in this article.
Missing data configuration:
Every charts has a configuration for the missing data. It is called Missing data and is located in the Style section. To access it, follow these steps:
- Go to the Style column and locate the Missing data section.
- Click on the dropdown and select a value. You can choose between:
- "no data"
- "0"
- "-"
- "null"
- " " (blank)
Adapt it to your situation and remember that you can edit it at once for several charts.
