How to determine the maximum number of checks per hour?

Question

1C

Those. there is an unloading of data from 1C for the month: check - check time.
You need to understand what is the maximum average per hour.
something like: on average, you get no more than 30 buyers per hour.
For the day, the arithmetic average (checks / for hours of work) is not suitable, because. for example, 100 people passed from 10 to 12, and then how to get
it. Yes, and I think if, for example, there is a one-time action like "happy hour" and 300 people come once a week, then this is more an exception from the statistics than the rule, but with the approach voiced above, the numbers will affect the result.

Answer 1

Well, as recommendations, look from the side of the BI system. Load this data there. And build different types of reports.
there was a case in QlikView, I loaded sales by checks from 25 stores for 8 years, also balances per day total, area, number of inhabitants.
And then I made simple graphs based on these data.
Hours, days of the week, months, years, types of goods, etc...