AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.1K members online now
4.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Studio interpreting NULL as 0

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

I have date based data where for some metrics some dates return null. I had hoped that the feature on a line graph to exclude missing items would work, but Studio seems to be recording the nulls as 0s, so it doesn't. I can't just exclude the dates as they have data for other metrics I'm plotting on the same graph.

 

It looks like the settings should allow for this, but they don't.

 

Any ideas?