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" = ...
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])
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])