Count (Distinct) With Condition
Hello Domo Experts,
I am having a hard time navigating around this one. My goal is to get a unique count of 'evaluation_id' where an error has occurred. I have created a column for when error occurred using beast mode, but when I try to count Distinct Eval Ids does not seem to give me what I want. Any help appreciated.
Thank you
Answers
-
Hi @jgospel
It's because of the extra columns you have displayed in your chart. Because you have Compliance Error, question_max_score and answer_value it's grouping by those so it's only looking at the compliance error within that specific group rather than at just the agent full name level. If you remove several of those columns that are for debugging your query will likely work.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
I tried and tested out a few scenarios and the results have nothing to do with additional columns in your table.
I see couple of potential issues with your code.
- While you mentioned that error occurs when
Question_max_score
is not equal toanswer_value
however your case statement isQuestion_max_score
=answer_value
instead ofQuestion_max_score
!=answer_value.
- It could also be issues with bracket/braces placement. Try using this:
COUNT(DISTINCT
(
CASE when (`question_max_score` != 'answer_value') AND (`Name_group` = 'compliance critical') then `evaluation Id`
END
)
)
1 - While you mentioned that error occurs when
-
Thank you both! It worked out :)
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 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