Forum Discussion

virus190's avatar
virus190
Helper II
5 years ago

How many calls at the same time?

Hello,   maybe someone can help, i would appreciate it.   I want to know how many calls were at the same time, i got this data from 1 day:     If i do this manually:     Is this...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

virus190 , Try a new column

measure =
var _1 = [Accepted]
var _2 = [Hang up]
return
if(not(isblank(countx(filter(table, [Accepted] >= _1 && [Accepted] <= _2),[Call ID]))),"x", blank())

 

or

 

measure =
var _1 = [Accepted]
var _2 = [Hang up]
var _3 = [Call ID]
return
if(not(isblank(countx(filter(table, [Accepted] >= _1 && [Accepted] <= _2 && [Call Id] <> _3),[Call ID]))),"x", blank())