Basically, I need to find the average, minimum, and maximum number of customers in the waiting room for each hour of the day.
I have a table with columns for the date and hour each customer arrived.
Average was pretty simple. I just found the frequency of each hour in the table and divided by the number of unique dates.
But min and max is messing with my head. I need to somehow make an array of the counts per hour each day and then find the min or max of it.
Any idea of how to do that?
I have a table with columns for the date and hour each customer arrived.
Average was pretty simple. I just found the frequency of each hour in the table and divided by the number of unique dates.
But min and max is messing with my head. I need to somehow make an array of the counts per hour each day and then find the min or max of it.
Any idea of how to do that?
