Hourly Item Sale Report

[QMcKay]

Search found this…

Custom report by hour

Report Template: [Sales Per Hour: 15, 25, 15, 20, 20] >Hour|Sales|Tx|AvgTx|%Sales @@SalesPerHour:6,22 Change the 6,22 parameter above to set your Start and End hours. For example, a full day would be: @@SalesPerHour:0,23 [image] @@SalesPerHour (SQL Script in Automation > Scripts) declare @StartDate datetime = convert(varchar(25),'{Start}',126) declare @EndDate datetime = convert(varchar(25),'{End}',126) declare @StartHour int = @1 -- set the First Hour you want to track declare @EndHour…