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

How to force a value to 0 when "No data" is displayed

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Frohm my spreadsheet source, I create a calculate measure:  COUNT_DISTINCT (id)

 

In some reports I filter this calculated measure on an attribute like status="open".

 

When my database does not match this filter I get as result a "No data"

I would prefer to get a 0 instead.

 

I would expect it would behave the same as:

SELECT COUNT_DISCTINT(id) From <datasource> WHERE ID ="open"

 

Any tip on how to force a value to a calculated measure ?