GROUPED BY Hour of day


Im using the GROUPED BY Hour of day to show the business day performance.
Our Business day starts from 09AM and Ends 24 Hours later 09AM (24/7) Im trying to change the start hour in the result to 09AM but did not find any solution until now.
Default is 12AM in the question


Hi @pmad
There’s currently no setting for business day or hour.
You would have to create it using SQL, where you would skewer the column’s time by 9 hours and then get the hour, which you would then need add 9 to again.

Has anyone solved this problem? Or, can anyone write that in SQL?
...I have the same problem but, for my business, our working day starts at 11 am and ends at 4 am

Thank you.