GROUPED BY Hour of day

#1

Hi

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

BR
PM

#2

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.