Nathan_Mahler

Discussions

COUNT(DISTINCT CASE WHEN THEN)
I am not sure why this formula is working, it seems fairly straight forward but I am just becoming a regular SQL user and our company just adopted DOMO. Any ideas? COUNT(DISTINCT CASE WHEN `Account.Status__c` LIKE 'Cancel%' THEN 'Canceled')
COUNT(DISTINCT... CASE WHEN... THEN)
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')