Date range dimension
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?