The following produces a count of 0 for "Other":
|stats count AS Contacts,
count(eval((in_value=1 AND duration!="")
OR (in_value=2 AND duration!="")
OR (out_value=1 AND duration!="")
OR (out_value=2 AND duration!=""))) AS Successful,
count(eval((in_value=1 AND duration="")
OR (in_value=2 AND duration="")
OR (out_value=1 AND duration="")
OR (out_value=2 AND duration=""))) AS Unsuccessful,
count(eval(in_value!=1 AND in_value!=2 AND out_value!=1 AND out_value!=2)) AS Other
BY groupCode
|fields groupCode, Contacts, Successful, Unsuccessful, Other
|addcoltotals Contacts, Successful, Unsuccessful, Other
If I change "Other" to the following, the count can and does include some Successfuls:
count(eval((in_value!=1 AND in_value!=2) OR (out_value!=1 AND out_value!=2))) AS Other
If I change all the ANDs to ORs, I get the same count as Successfuls.
... View more