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?
- 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 日本支部