Beast Mode for Count Distinct with Condition
I want to get count of values in a column based on a condition for another column:
Count(Distinct 'visitor_id' ) where visitor_called = 'Y'
The above give me a syntax error.
Trying with 'Case':
WHEN `visitor_called` = 'Y' then COUNT(DISTINCT `visitor_id`)
This returns me overall counf for distinct visitor ID but not for condition specified.
Any help would be appreciated.
You very nearly had it right. Try wrapping your entire case statement in the count distinct function:
WHEN `visitor_called` = 'Y' then `visitor_id`
-- note I'm NOT using the "else" portion of the case statement. That's because, if `visitor_called` is not 'Y', then I want the case statement to return NULL. NULL is not included in aggregate functions like count()
That worked like a charm ! ? Thank you0
If we didn't specify the visitor_called, but wanted to count all unique visitor_ids for each visitor_called, any idea how we could do that in Beast Mode?
Will be of great help. I'm going through a similar issue.0
@hamza_123 If my understanding is correct, your requirement is to see the count of distinct visitorIds for each available value of visitor_called (yes, no, etc.)
In that case, build a simple calculated metric with definition count(distinct visitor_ID) and apply it on the graph/table for the visitor_called.
Example: if on a horizontal bar graph,pull visitor_called on x-axis and calculated metric on y-axis.
Let me know if my understanding is incorrect. In that case, a sample of available data and required data would help.1
That worked out! Thank you very much.0
- 7.7K All Categories
- 2 Connect
- 918 Connectors
- 244 Workbench
- 476 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 35 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 16 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 24 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部