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

Can I hide data when it is blank or null

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

In Data Studio 360, how can I hide the data so that it won't show in the report if the data is blank or null?

 

Thanks,

Jim

1 Expert replyverified_user

Can I hide data when it is blank or null

Google Employee
# 2
Google Employee

Hi Jim,

 

You can use the editor filters at the report level to filter out null data. You'll have to filter out null data for every dimension that you use in the report. Check out this article for more info:

https://support.google.com/360suite/datastudio/answer/6291066?hl=en

 

Can I hide data when it is blank or null

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks Dave!

 

Re: Can I hide data when it is blank or null

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Hi,
In DataStudio, if I use Filter and use the 'Contains' option, what is the
syntax if I want to include more that 1 value?
for example, I want to include 'John' and 'Mary' in the filter, what is the
syntax to include these 2?

Thanks,
Jim

Can I hide data when it is blank or null

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi,

In DataStudio, if I use Filter and use the 'Contains' option, what is the syntax if I want to include more that 1 value?
for example, I want to include 'John' and 'Mary' in the filter, what is the syntax to include these 2?
 
Thanks,
Jim

 

Can I hide data when it is blank or null

Follower ✭ ✭ ✭
# 6
Follower ✭ ✭ ✭

Hi Jim, 

 

You'll have to use regex rather than contains. 

 

The syntax for 'or' in Regex is John|Mary