Data Studio
2.2K members online now
2.2K 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 ?