Count values between two time stamps

[LeeFord]

Hi,

I effectively have phone call records that have a start and end time on them. Is there anyway to calculate how many calls were active at the same time along a line chart? (If I select the start or end time as the axis and count the ID of the call record, unless more than one record has the exact same timestamp its a straight line.)

Thanks

Lee

[Ashish_Mathur]

Hi,

What do you mean by "At the same time"?  Do you mean how many people were talking at 13:42:15?  Share some data and also the expected result.

[LeeFord]

Hi Anish,

Thats exactly what I'm after thank you. I've put a linke for some sample data.

There is a start time, end time and to and from telephone number.

https://www.dropbox.com/s/me91dx6kypplor0/calls.csv?dl=0

Thanks,

Lee

[Ashish_Mathur]

Hi,

I will not be able to help you with this.  Sorry.

[bizbi]

Hello Lee,

Couldn't think of a direct way to get the count at each instance, but if the number of records is limited try using 'as Timeline' visual to get the following representation from where manually the times of interest can be explored:

[LeeFord]

Hi,

Thanks for the reply, I'm looking at 1000s of records, so might be a little tricky!

Thanks again.

Lee