Forum Discussion
Solved
Create Expression counting a single column but using various qualifying criteria
Is there a way to write an Expression to calculate the total from "report (1) column (3) with criteria (a) AND report (1) column (3) with criteria (b) "What I am trying to do is count the number of calls where lead source is "A" and call duration > 30 seconds AND where lead source is "B" and call duration > 15 Right now I can do the first part in one measure and the 2nd part in another, is there a way to count them in a single measure? Technically I want to count 3 in one so actually include lead source "C" and call duration >5
4 Replies
ryan_mayuSuper User
could you pls proivde some sample data and expected output?
Calls Source Call Duration 555-555-5555 Referral 65 555-555-5555 Referral 20 Count Where Source IN { "Referral'}, 555-555-5555 Referral 65 Call Duration >30 555-555-5555 Referral 13 555-555-5555 Referral 85 3 111-111-1111 Commercial 82 111-111-1111 Commercial 61 111-111-1111 Commercial 28 Count Where Source IN { "Commercial'}, 111-111-1111 Commercial 35 Call Duration >15 111-111-1111 Commercial 12 111-111-1111 Commercial 3 111-111-1111 Commercial 11 5 111-111-1111 Commercial 82 999-999-9999 Advertisement 73 999-999-9999 Advertisement 2 999-999-9999 Advertisement 35 Count Where Source IN { "Advertisement'}, 999-999-9999 Advertisement 1 Call Duration >5 999-999-9999 Advertisement 13 999-999-9999 Advertisement 4 3 In This example I want a single returned value of 11
