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

Nathan_Mahler
Nathan_Mahler Member
edited January 2023 in Beast Mode

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')