Counting rows with a specific numerical value when using 'Group By'
Hi there  I'm new to Domo so apologies if this has been asked before and I have been unable to find the answer. I am using the "Group By' function in my ETL and in one of my aggregate columns I want to show the count of all the rows that have the numerical value of 80.
I have tried the formula COUNT(`ptstatus`= '80') and COUNT(`ptstatus`= 80) but in both cases it just returns a count of all of the rows not just those with a value of 80.
In the same Group By I have a similar formula working on a text field COUNT(`stage_name`= 'ACTIVE') and this works fine.
Can anyone tell me why the formula is not working on the numerical field?
Best Answer

Count is counting the number of non null values. You’ll want to return a value only if you want it counted. You can use a CASE statement in your COUNT to do this
COUNT(CASE WHEN `ptstatus`=80 THEN `ptstatus` END)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers

Thanks Grant  that solved the issue.
0
Categories
 7.3K All Categories
 13 Getting Started in the Community
 141 Beastmode & Analytics
 1.8K Data Platform & Data Science
 54 Domo Everywhere
 2K Charting
 1K Ideas Exchange
 903 Connectors
 236 Workbench
 342 APIs
 77 Apps
 19 Governance & Productivity
 234 Use Cases & Best Practices
 50 News
 473 Onboarding
 572 日本支部