Average daily traffic

[Anonymous]

Hello

I have several Excel files in which a 'Time' column has the exact time a phone call begins. (Files are created on a monthly basis)

In the 'Date' column we can find the day a phone call came in.

Date	Day	Time
01/12/16	Thu	14:09:20
02/12/16	Fri	13:58:09
13/12/16	Tue	11:09:15
13/12/16	Tue	16:34:35
15/12/16	Thu	11:52:11
19/12/16	Mon	11:21:04

I am now looking for a way to indicate the average daily telephone traffic per hour. (over several months, even years)

Can anyone help me?

Thanks in advance

[tcullinane]

Load the data without the Time field, instead convert this to an Hour.

Add a Count(Time)

and group by the Date and Hour.

You will then have a count of calls per hour per day

(You could do this in a measure in the app by adding a calculated dimension to create the hour and counting the times, but depending on what you want and how many calls per hour you get it might be better to calculate it in the script)

[Anonymous]

Thanks,

I converted the time field into an Hour

This way I was able to create a table with Hour as dimension, with a count Trunk as measurement.

This gives an picture about the total number of calls received on this date.

But when I use the Trunk average as measurement, the results are all over the place.

(Trunk is a unique key to identify each call)

[Anonymous · Accepted solution]

count(trunk)/count(distinct(date)) did the trick