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

Between not working with "hour"

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

I'm setting a filter for hours between 15:00 and 22:00

In the filter the option for "between" doesn't work, however setting each hour I want to include in an OR rule does, is this a known issue?

hour.PNG

Marked as Best Answer.
Solution
Accepted by topic author Andrew S
April 2017

Between not working with "hour"

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi Andrew,
Have you tried entering 1500 and 2200 instead of just 15 and 22?

Between not working with "hour"

[ Edited ]
Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆

Brilliant, thanks! I think I was thrown off by the examples:

examples.PNG

Between not working with "hour"

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Sure, no worries!