Average of count

irksy

New Member
Joined
Jul 10, 2013
Messages
29
Hi All

I have a table with 6 columns;
Agent - Staff Member
Called - Phone number called
Internal/External - Where the call went
Date - Date of Call
Time - Time of Call
Length - Length of Call

I am trying to build a Pivot Chart, which shows the average number of calls made by each agent at times of the day ie how many they made between 9 and 10, 10 and 11 and so on.

I have run into trouble with getting an average per hour slot, currently I am using count of the numbers to give me a value which adds up all the calls made between 9 and 10 , but as soon as I try to average it, it adds all the phone numbers up and averages that number, what I want is how many calls made between 9 and 10 divided by number of days, is it possible to do this directly in the pivot table/chart or do i need to add an extra formula into the worksheet?

Does this make sense?
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Hello,

It looks like you need a calculated field ... :wink:

Take a look at Debra's brilliant explanation ...

403 Forbidden

HTH
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top