Comments
-
Thanks again @ST_-Superman-_ . Judging by the formula working in the sample set provided, it would appear that my actual data set must be the problem. The same type of problem is still occurring - the first comparison clause is controlling 'Customer1' as well and modifying the clause that filters on campaign_name makes no…
-
Attached
-
@ST_-Superman-_ Thank you for the help!! You are correct in that I'm intending to only calculate against the contact ids related to the value1 campaign; so the result would be 4/50. And I didn't use count distinct because every contact id should already be discinct. I tried the formula you suggested, and the results appear…
-
Thank you! I could be missing something but believe I have two additional CASE statements. I color-coded below: CASE WHEN SUM(case when `campaign_name` = 'VALUE1' AND `Abandon_Time` > 15 then 1 else 0 end) / COUNT(`contact_id`) <= 0.07 THEN 'Good' WHEN SUM(case when `campaign_name` != 'VALUE1' AND `Abandon_Time` > 15 then…
