Forum Discussion
Pivot Table Avg Times
Good morning, I am attempting to create an excel pivot table that takes avg times per day so that I can plot in a bar chart. I would like to group each time by hour and calculate how many instance...
Hi Sergei, thank you for responding. I am interested in the occurrences and not the avg times. Our goal is to find out the average number of appointments at specific times a day so that we can plan staff scheduling accordingly.
Have taken a sligthly different route as it seems MROUND does not always put the [Arrival Time] in the appropriate Time Slot:
In attached file the Avg measure is SergeiBaklan's one
- Is there a way to get to the average occurrences instead of the percentage? for example, at 12:00 PM we had an average of x amount of appointments.
- https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/75890
I should also add, that theses averages are based on per day, so per day we would have x amount at y time and so on. I hope that makes sense.