Forum Discussion
LeeFord
8 years agoRegular Visitor
Count values between two time stamps
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 star...
Ashish_Mathur
8 years agoSuper User
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.
- LeeFord8 years agoRegular Visitor
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_Mathur8 years agoSuper User
Hi,
I will not be able to help you with this. Sorry.