I need to make a report in sales to check which hour most sales occur. Normally in sql this would be easy, but the documentation in query reports does explain how to make a group by time based. So my question is:
I need to check the amount of sales occured in each hour bracket grouped by day of the week. Basically see what hours we have more sales on Monday, Tuesday, etc. This requires a group by on the day of the week and to create a new column (in query) that would represent the hour of sale (extracted from an existing column such as date or creation date).
How would one go about this. I am thinking of doing script report. But wanting to know if there is another user friendly way to do this.