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

Date range dimension

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

hi all

 

I'd like to regroup hours (formatted as Hour (HH)) into ranges within a new text dimension, something like 7AM to 9AM = "early morning".

my hours dimension currently returns a list of timestamps "1 AM", "2 AM" etc.

 

I thought I'd use a CASE function, but I've been unable to find the correct syntax for the boolean test.

can anyone help?

 

 cheers!