Forum Discussion
duggy
Advocate II
Advocate IIAveraging by Hour
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 p...
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.
Greg_Deckler
Community Champion
Community ChampionJust 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.
duggyI 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!