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

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 
Thanks Grant  that solved the issue.
0
Categories
 All Categories
 1.3K Product Ideas
 1.3K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 281 Workbench
 2 Cloud Amplifier
 4 Federated
 2.8K Transform
 83 SQL DataFlows
 541 Datasets
 2.2K Magic ETL
 3.2K Visualize
 2.3K Charting
 518 Beast Mode
 26 Variables
 555 Automate
 129 Apps
 408 APIs & Domo Developer
 18 Workflows
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 343 Distribute
 85 Domo Everywhere
 257 Scheduled Reports
 1 Software Integrations
 81 Manage
 80 Governance & Security
 2 Product Release Questions
 Community Forums
 41 Getting Started
 27 Community Member Introductions
 78 Community Announcements
 4.8K Archive