Hourly Sales by Ticket Type

[Craig_Farman]

Is it possible to build a report showing the hourly sales of a certain ticket type.

If so how would I go around doing this.

Regards

Craig

[Jesse]

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…

[Jesse]

OK I just realized that was you in the tutorial I just linked…

[Craig_Farman]

Thanks Kendash that’s the tutorial I got before but that pulls hourly sales for everything I just need a specific Departments Hourly sales.

Cheers

[Jesse]

@Craig_Farman

specific Departments Hourly sales.

So we need to change the SQL. I am looking at something with CUSTOM REPORT TAGS give me a moment I will get back to you.

[Jesse]

Are you wanting Department or Ticket Type? You have asked both… its confusing me.

[Craig_Farman]

by department would suit my needs much better

sorry

[Jesse]

How many departments do you have?

[Craig_Farman]

I only need the hourly sales for 1 department (I have 8 departments but I only need to report this way for one)

[Jesse]

Ok so we need to determine what that departments Department ID is.

[Craig_Farman]

In my case the department is called POOL

[Craig_Farman]

Hey Kendash,

did you manage with this ?

Thanks

Craig

[Craig_Farman]

Hey Guys,

Sorry I need to re-establish this old thread as I still haven’t solved my problem with it.

Basically I need to change the SQL to report these details against a certain department.

Or the even better solution would be to change this to report against a selection of menu groups if possible.

Once again thanks for all your help,

Craig