Beast Mode for Count Distinct with Condition
I want to get count of values in a column based on a condition for another column:
Count(Distinct 'visitor_id' ) where visitor_called = 'Y'
The above give me a syntax error.
Trying with 'Case':
WHEN `visitor_called` = 'Y' then COUNT(DISTINCT `visitor_id`)
This returns me overall counf for distinct visitor ID but not for condition specified.
Any help would be appreciated.