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

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

Filtering on numeric fields doesn't have greater/less than (but does have text options)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

These filter options don't look right for numeric values - there's no greater/less than, but there are things like "Starts with"!

 

Screenshot 2016-10-22 at 10.40.09.png

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Danny T
October 2016

Filtering on numeric fields doesn't have greater/less than (but does have text options)

Participant ✭ ✭ ☆
# 4
Participant ✭ ✭ ☆

It seems that right now you can only use one of these four expressions in filters: Equals, Contains, Starts with and Regex- no matter what data type you want to filter.

https://support.google.com/360suite/datastudio/answer/6291066 (How filter properties work)

I believe this will change in the future.

 

View solution in original post

Filtering on numeric fields doesn't have greater/less than (but does have text options)

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

"Days Since Last Session" is a string data type, not a number. That's why there are no 'greater than' or 'less than' operators.

https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=user&jum...

 

Re: Filtering on numeric fields doesn't have greater/less than (but does have text options)

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I don't know if I changed it, but mine is set to number and I still have the same options:

 

Screenshot 2016-10-23 at 08.36.38.png

Marked as Best Answer.
Solution
Accepted by topic author Danny T
October 2016

Filtering on numeric fields doesn't have greater/less than (but does have text options)

Participant ✭ ✭ ☆
# 4
Participant ✭ ✭ ☆

It seems that right now you can only use one of these four expressions in filters: Equals, Contains, Starts with and Regex- no matter what data type you want to filter.

https://support.google.com/360suite/datastudio/answer/6291066 (How filter properties work)

I believe this will change in the future.