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

Analytics
4.5K members online now
4.5K members online now
Ask questions about filter set-up and issues with using filters in Google Analytics reports
 
Guide Me
star_border
Reply

Custom Report Filters - and vs or??

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I'm pretty new to GA, so forgive my noob question.

 

When creating my custom report I'm attempting to return Sessions grouped by my dimension Event Label.  Because event label has many different values I'm attempting to filter for only results having 25%, 50%, 75% and 99%. But as far as I can tell the filter only uses AND and I see no option for OR.  

 

How ought I filter for only these 4 groupings?

 

On a side note, is custom reports the closest thing to a pivot table in GA?  I'd Like to drag and drop the dimensions and metrics I'm interested in irrespective of GA's stock reports.  

 

Thanks!!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Benjamin C
April 2016

Re: Custom Report Filters - and vs or??

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆
Benjamin,

Try this and let me know if this works -
^25%$|^50%$|^75%$|^99%$

View solution in original post

Re: Custom Report Filters - and vs or??

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆
You could use regex option rather than exact, for example - 25%|50%|75%|99%

Re: Custom Report Filters - and vs or??

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks for the reply but using regex doesn't exclude the other values.

 

Screen Shot 2016-04-14 at 3.52.42 PM.png

 

 

Screen Shot 2016-04-14 at 3.50.25 PM.png

Marked as Best Answer.
Solution
Accepted by topic author Benjamin C
April 2016

Re: Custom Report Filters - and vs or??

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆
Benjamin,

Try this and let me know if this works -
^25%$|^50%$|^75%$|^99%$

Re: Custom Report Filters - and vs or??

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

That worked, thanks!

 

After reading about regular expressions, this solution below is less elegant but also worked.  Although I am confused by excluding "...." 4 wild cards.  I'd assume it would exclude anything with 4 characters, but it excluded anything with 4 or more characters. 

 

Screen Shot 2016-04-15 at 9.27.53 AM.png

 

Thanks again!