COUNT(DISTINCT... CASE WHEN... THEN)

Nathan_Mahler
Nathan_Mahler Utah ⚪️
edited January 4 in Beastmode & Analytics

Our company just adopted DOMO and this beast mode is always registering as invalid, but it seems to be the correct syntax (or so I thought), any ideas as to what I am doing wrong

COUNT(DISTINCT CASE WHEN `Account.Status__c` LIKE 'Cancel%' THEN 'Canceled')