How to remove null in looker studio ?

How to remove null in looker studio ?

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)
Change null value for 0 or a blank space in Looker Studio.

Adapt it to your situation and remember that you can edit it at once for several charts.

More function to use with Looker Studio

CAST
:
Transform you data with the CAST function in Looker Studio
SUM
:
Mastering the SUM Function: A Detailed Guide to Calculating Large Datasets with Looker Studio
WEEK
:
Analyzing and Presenting Your Data by Week: The Essential Guide to Using the WEEK Function in Looker Studio
STDDEV
:
Understanding the Power of the STDDEV Function in Looker Studio for Improved Data Analysis and Strategic Decision Making
MAX
:
Mastering the Use of MAX Function in Looker Studio for Enhanced Business Data Analysis and Insights

Need a clearer view of your data?

Find +50 free templates for Facebook, Instagram, Google Ads and more!

Get it for free