Forum Discussion

LeeFord's avatar
LeeFord
Regular Visitor
8 years ago

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...
bizbi's avatar
bizbi
Advocate I
8 years ago

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's avatar
    LeeFord
    Regular Visitor
    8 years ago

    Hi,

     

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

     

    Thanks again.

    Lee