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:
Time(SessionClosedTime, 'hh') as Hour
Time(Time#(SessionClosedTime, 'hh:mm:ss'), 'hh') as Hour
Retrieving data ...