Integrate all of your marketing channels into Google Data Studio. BUILD A REPORT IN 2 MINUTES December 19, 2022 We’ll cover: Make your 1st report in a minute Null values are very common. When you attempt to blend data from different data sources. This article will show you how to turn those null values into zero in a numeric format. So you can mathematically operate them.
For whatever reason, you may have attempt blending data from different sources and expect your numeric Country Email List columns to return numbers that could be mathematically operate. But it kept returning null for some reason, which can sometimes leave you frustrate and furious.
Here we’ll show you how we deal with null responses
When we blend data – especially when we are sure that our combinations are faultless. We need those null values shown in text or strings data format to be return in numeric formats to either get a grand total value or use the numbers for more arithmetic expressions.
Check out our free templates gallery
Check out our free templates gallery How To Transform Null Values Into Zero on Looker Studio.So here’s what you should do when you see that null value, and you need to change that to a number or zero. The formula Cn Leads often use for this is know as the NARY_MAX formula and is express as SUM(Column name) + SUM(NARY_MAX(Column name, 0)). The formula above can be copie and paste on your Looker Studio Report under calculate fields.
All you will need to do after blending your data sources would be to replace the column names with the actual names of the columns you need to be change. First, you must blend your two data sources using the left join or any join parameter favorable to you.