Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called SessionClosedTime, which is in the format HH:MM:SS
How can I group these values into one hour ranges, so that I can display my data by hour?
Create a field like:
Load
Time(SessionClosedTime, 'hh') as Hour
Or,
Load
Time(Time#(SessionClosedTime, 'hh:mm:ss'), 'hh') as Hour
interval(timesessionclosetimefield,'hh')