Data Studio
2.2K members online now
2.2K members online now
Ask questions about Data Studio
Guide Me

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 ?