Forum Discussion

setis's avatar
setis
Post Partisan
6 years ago
Solved

Matching records

Dear all,

 

I have a telephone book that looks like this:

 

 

I am trying to calculate the not answered calls. This is, calls that have been placed in queue but do not have a "descript" = conversation. 

 

Any idea on how to approach this?

 

thank you in advance!

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Something like this

    sumx(filter(summarize(table, table[Call id], "_q",calculate(count(table[Call id]),Table[descript] = "placed in queue")
		, "_c",calculate(count(table[Call id]),Table[descript] = "conversation")), [_q]>0 && ([_c] =0 || isblank([_c]))),[_q])

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Something like this

    sumx(filter(summarize(table, table[Call id], "_q",calculate(count(table[Call id]),Table[descript] = "placed in queue")
		, "_c",calculate(count(table[Call id]),Table[descript] = "conversation")), [_q]>0 && ([_c] =0 || isblank([_c]))),[_q])