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.