and and or condition in set analysis

[sai_12]

Hi everyone,

I have a requirement where

I want to only count clients where(case_Status is open) and (email_status=active or sms_Status=active or phone_Status=active)

so i am using this

count({<Email_status={'active'}>+<SMS_status={'active'}>+<Phone_Status={'active'}>},{<Case_Status='Open'>} distinct [client]))

But i am getting error, all i want is count for case_status=open and any of email_Status,sms_Status or phone_Status is active

[Mark_Little]

Hi,

Certainly not the best approach but should give you the correct answer.

count({<Email_status={'active'}, Case_Status='Open'>} distinct [client]) +

count({<SMS_status={'active'},Case_Status='Open'>} distinct [client]) +

count({<Phone_Status={'active'},Case_Status='Open'>} distinct [client])

[marcus_sommer · Accepted solution]

In general such approach should work but there is a small syntax issue and it should look like:

count({<Email_status={'active'}>+<SMS_status={'active'}>+<Phone_Status={'active'}> * <Case_Status='Open'>} distinct [client]))

[anat]

count({(<Email_status={'active'}>+<SMS_status={'active'}>+<Phone_Status={'active'}>)*<Case_Status='Open'>} distinct [client]))