Averaging by Hour

[duggy]

Hi,

I have multiple stores where the staff schedule is for every 5 minutes. I need to work out the median staff quantity per hour for each store for each day for each staff type. 🙂

Is this possible? I have been hunting the solution for a couple of days.

Store	Date	Time	Hour	Quantity	Staff Type
Peters	01-Feb-18	9:00 AM	9	4	Cashier
Peters	01-Feb-18	9:05 AM	9	4	Cashier
Peters	01-Feb-18	9:10 AM	9	4	Cashier
Peters	01-Feb-18	9:15 AM	9	4	Cashier
Peters	01-Feb-18	9:20 AM	9	4	Cashier
Peters	01-Feb-18	9:25 AM	9	4	Cashier
Peters	01-Feb-18	9:30 AM	9	4	Cashier
Peters	01-Feb-18	9:35 AM	9	4	Cashier
Peters	01-Feb-18	9:40 AM	9	4	Cashier
Peters	01-Feb-18	9:45 AM	9	4	Cashier
Peters	01-Feb-18	9:50 AM	9	4	Cashier
Peters	01-Feb-18	9:55 AM	9	4	Cashier
Peters	01-Feb-18	10:00 AM	10	6	Cashier
Peters	01-Feb-18	10:05 AM	10	6	Cashier
Peters	01-Feb-18	10:10 AM	10	6	Cashier
Peters	01-Feb-18	10:15 AM	10	6	Cashier
Peters	01-Feb-18	10:20 AM	10	6	Cashier
Peters	01-Feb-18	10:25 AM	10	6	Cashier
Peters	01-Feb-18	10:30 AM	10	6	Cashier
Peters	01-Feb-18	10:35 AM	10	6	Cashier
Peters	01-Feb-18	10:40 AM	10	6	Cashier
Peters	01-Feb-18	10:45 AM	10	6	Cashier
Peters	01-Feb-18	10:50 AM	10	6	Cashier
Peters	01-Feb-18	10:55 AM	10	6	Cashier

[Greg_Deckler · Accepted solution]

Just put Store and Hour in a table. Don't summarize Hour. Now put Quantity in the table and choose the "Median" aggregation. Like Page 1 of the attached file. 

[duggy]

I dont know why I didnt realize this myself... When you too deap into it you dont take a chance to step back.

[Greg_Deckler]

That's why we're here, to be that other set of eyes!