Case Statement Help
I'm trying to write a simple case statement, but it isn't working as intended. My data set has an attribute for Customer ID. When populated, this indicates that a customer was attached to a sale transaction. It populates with zero if no customer was attached. I want to count the unique customers that were attached, and exclude the fields populated with zero. Here's my current syntax:
(CASE WHEN `customerID` > 0 THEN COUNT(DISTINCT `customerID`) End)
Even with this Beast Mode, I believe it's still counting zero as a unique Customer ID, because all of my values have one additional number in the count tally. In the example image, the count tally is 5, when it should be 4. What am I doing wrong?
0
Best Answers
-
@MichelleH That worked! Thank you.
0
Answers
-
@MichelleH That worked! Thank you.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive