Forum Discussion

timwilson's avatar
timwilson
Frequent Visitor
9 years ago
Solved

Counting concurrent calls

Hi,   I need to count the number of concurrent calls.   I have a start datetime of each call and an end datetime of each call, anyone have any ideas on counting the amount of concurrent calls?  ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi timwilson,

     

    Maybe you can try to use "countrows" function with calculate column to get the count of concurrent call.

     

    Sample:

    Concurrent Calls= COUNTROWS(FILTER('Table',[StartDate]>=EARLIER('Table'[StartDate])&&[EndDate]<=EARLIER('Table'[EndDate])))

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi timwilson,

 

Maybe you can try to use "countrows" function with calculate column to get the count of concurrent call.

 

Sample:

Concurrent Calls= COUNTROWS(FILTER('Table',[StartDate]>=EARLIER('Table'[StartDate])&&[EndDate]<=EARLIER('Table'[EndDate])))

 

Regards,

Xiaoxin Sheng

jpurcell's avatar
jpurcell
Advocate I
8 years ago

is it possible to further filter this by user? to count the concurent events of each user, not of everyone.