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 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

5 Replies

  • 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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    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.