mikenz1983
New Member
- Joined
- Oct 2, 2014
- Messages
- 33
Hey Guys
I am drawing a blank here and i know i have done this before, but for the life of me cant remember
i have a worksheet that holds records of all the calls i have received into the business and the different departments, the general format looks like this
Date Day Duration
14/06/2021 Mon 0:02:05
14/06/2021 Mon 0:03:59
14/06/2021 Mon 0:06:09
14/06/2021 Mon 0:06:04
this worksheet has about 25k entries so goes through the other days of the week also and lists the departments that may have recieved the calls
i did a pivot on the data to see if i could see the "average" call volumes received on a certain day of the week, but its returning an error.
so my question is, how do i see the average of calls delivered per day by department, ideally that will be picked up in a pivot table
Thanks
I am drawing a blank here and i know i have done this before, but for the life of me cant remember
i have a worksheet that holds records of all the calls i have received into the business and the different departments, the general format looks like this
Date Day Duration
14/06/2021 Mon 0:02:05
14/06/2021 Mon 0:03:59
14/06/2021 Mon 0:06:09
14/06/2021 Mon 0:06:04
this worksheet has about 25k entries so goes through the other days of the week also and lists the departments that may have recieved the calls
i did a pivot on the data to see if i could see the "average" call volumes received on a certain day of the week, but its returning an error.
so my question is, how do i see the average of calls delivered per day by department, ideally that will be picked up in a pivot table
Thanks
Last edited: