Forum Discussion

virus190's avatar
virus190
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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())

  • virus190's avatar
    virus190
    Icon for Helper II rankHelper II
    5 years ago

    Hello amitchandak ,

     

    this also works, so thank you for the quick solution, but it also only works with a few rows (look at my answer to Icey)

    Do you have a solution with a lot of rows?