Count No of Records Based on unique ID
Trying to count number of unique records for each customer id in beast mode. Currently using: COUNT(DISTINCT CASE WHEN `unique ID`=`unique ID` THEN COUNT(DISTINCT `Records`) END) Any help? Keep getting error message.
