COUNT(DISTINCT... CASE WHEN... THEN)
Nathan_Mahler
Utah ⚪️
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')
0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 895 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部