Does Square have a report for time of day of sales for a specified day of the week over time?

[TPT_Amanda]

I'm trying to determine hours I should be open on Monday's in 2017 based on time of day of sales on Monday's in 2016. Is there a way I can drill the report down to only show me aggregate info on Monday's in 2016? Currently I get time of day of sales averaged for the entire week, for the entire year. I'd like it to be just a little more specific if possible.

[woolypig]

Have there been any movement in product on this feature?  

As a business, it would be helpful to identify the trends on what times of days are not worth opening, etc. 

This would be helpful as I cannot pull every Sunday from 8-9 AM sales reports.  Seems like an easy feature where you can filter by day, but it would be extremely helpful

[Helen]

No news yet @woolypig but thanks for letting us know why you'd find this helpful — that's important for the Reporting team as they plan which features to build next. If we have any updates to share we'll post here to let you all know.

[Clatter]

I also would like that feature.

We need it to help us do smarter scheduling.

A shift will come in to help the barista through the busiest time.

But when does the business start on Wednesdays? It's different that Monday, different from Saturday, etc.

[PepperParkCoffe]

Count me in!  Long time Square user (4+ years) with a coffee shop and we really need the ability to view sales per hour per day.  It truly is important to know the sales per hour for scheduling staff and as a coffee shop, to see who is upselling on shift and who isn't.  We want to offer incentives for staff who upsell and increase sales, but we cannot without a sales per hour feature.

Come on Square, you guys are the best in the business and this is not that difficult.  You already offer it in a weird backwards way on the comparison graph, just make the data downloadable to Excel, we can take it from there!

[Mathew]

Yes we would love this feature too!

We need to shave our opening hours and to do so need to look at sales figures by the hour on each day. I'm with the other guy who said just make it downloadable as a spreadsheet and we can do the rest

THanks to the Square Team

[mermer415]

In the report when looking at your sales by hour, is 3PM the data from 3-4PM?

[dingo4]

Count me in too... We desparatly need this feture

[Tailholtcoffee]

The title of this thread has been edited from the original: Daily average

I would like to see the daily averages by day. Example: what are the average daily sales for every Tuesday? Or every day of the week. Can anyone tell me how to get that information?

[GlassJudy]

You'll have to manually calculate the averages, but if you navigate from your Dashboard > Reports > Sales Summary, then set the date range to whatever period you're interested in, you'll get a report just under the main graph that breaks the sales out by day during that period.  Hovering over the bar for each day will bring up the total of that day's sales for the period.  Divide the total sales by the number of weeks in your period for the average.

A quick search didn't bring up any way to automate this, but it would be very simple for Square to do.  There may be other ways to do this in Square, but this is the best one I found.

[nextmike]

I would honestly expect this to be a basic report for a POS system.  The data is easily available.  We are a bar and need to determine if opening an hour later on Friday or Saturdays make sense.  This report is CRITICAL for determining business hours based on real data.  Sqaure, this request has been open for over a year.  Is this on the roadmap or not?