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

Can I exclude some Google Analytics results on a bar chart?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to show how much traffic our site got from social media. Unfortunately, when I pull it up in Google Data Studio, it has this giant "not set" category which makes all other unviewable. Ideally, I could remove the "not set" category as well as other sites I'm not concerned with (glassdoor, blogger, etc)

 

Screen Shot 2017-07-18 at 1.07.12 PM.png

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Asbury S
July

Re: Can I exclude some Google Analytics results on a bar chart?

Follower ✭ ✭ ✭
# 6
Follower ✭ ✭ ✭

Something else is at work in your case - I can't figure out why there's no data. 

 

Here's a similar situation I set. Just a table from GA:

2017-07-19 (22).png

 

And a filter set to it:

 

2017-07-19 (21)_LI.jpg

 

What happens, if you only apply (not set) exclusion?

 

 

 

View solution in original post

Can I exclude some Google Analytics results on a bar chart?

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

Hi Asbury!

 

Yes, just create a Filter that will exclude the Social Network = "(not set)".

 

Hope that helps!

Can I exclude some Google Analytics results on a bar chart?

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thank you! That's a million times easier than the work-around I was trying! Is there a way to exclude more that one thing though? If i try to exclude (not set) and then try to exclude Glassdoor, the chart freaks out. I've tried entering it every way I can think of.

Can I exclude some Google Analytics results on a bar chart?

Follower ✭ ✭ ✭
# 4
Follower ✭ ✭ ✭

You can create a combined filter, using logic "and", "or". Or you can add multiple Filters on one element - in this case second filter will work on what's left from the first one, etc. So in your case - try to update your filter with "and" logic and list everything you want excluded. PS - you will find AND link under and left of your filter setting line.

Re: Can I exclude some Google Analytics results on a bar chart?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Could you provide a screenshot of what you mean? I have tried every which way to have it exclude more than one thing but it always will give me "no data". The way I assume would work is in my screenshot below. As you can see, Data studio does not accept that way. I have tried it with time series, bar chart, and table and they all have the same outcome. I have tried using AND and I've tried using OR.

 

Screen Shot 2017-07-19 at 8.59.38 AM.png

Marked as Best Answer.
Solution
Accepted by topic author Asbury S
July

Re: Can I exclude some Google Analytics results on a bar chart?

Follower ✭ ✭ ✭
# 6
Follower ✭ ✭ ✭

Something else is at work in your case - I can't figure out why there's no data. 

 

Here's a similar situation I set. Just a table from GA:

2017-07-19 (22).png

 

And a filter set to it:

 

2017-07-19 (21)_LI.jpg

 

What happens, if you only apply (not set) exclusion?

 

 

 

Can I exclude some Google Analytics results on a bar chart?

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

If I only exclude "(not set)" it works great. In fact, I could exclude anything else as well, facebook for example, but trying to exclude more than one thing at a time freaks it out. I'm just pulling from Google Analytics, I don't know what the problem is...

Re: Can I exclude some Google Analytics results on a bar chart?

Follower ✭ ✭ ✭
# 8
Follower ✭ ✭ ✭

Lets debug in small steps.

 

1. Does it only act like that on your Social Networks field? Try experiment with some other dimension? 

 

2. And what happens if you put two separate filters like this (each just one exclusion)?

 

2017-07-19 (23).png

Can I exclude some Google Analytics results on a bar chart?

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭

1. I tried doing it on a separate chart filtering campaign instead of social network. Everything worked fine as one filter or when split into two filters. So "Social Network" seems to be the problem.

2. Putting it in separate filters has the same effect - no data

Can I exclude some Google Analytics results on a bar chart?

[ Edited ]
Follower ✭ ✭ ✭
# 10
Follower ✭ ✭ ✭

OK.. That's weird. But try one last trick - instead of exclusion filter, try to make Inclusion one - put all the networks you want to see in the chart/table:

 

Include -> Social Network -> RegExp Match -> Facebook|Twitter|...

 

( Pipe | means OR) - put them all there by dividing with it.

 

See what happens now.