Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Average daily traffic

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.

   

DateDayTime
01/12/16Thu14:09:20
02/12/16Fri13:58:09
13/12/16Tue11:09:15
13/12/16Tue16:34:35
15/12/16Thu11:52:11
19/12/16Mon11: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

 

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

3 Replies
tcullinane
Creator II
Creator II

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
Not applicable
Author

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
Not applicable
Author

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