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
4K members online now
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!