Subtracting a "COUNT" result from a given value
I'm assuming I have this completely wrong.
1344  COUNT(`Room/Row Id`) is what i'm trying to do. 1344 represents the total spaces available in a cooler unit. the COUNT equation is how many spaces are currently filled.
The underlying math here is 1344764=580, however i'm getting a result of 12,676.
Best Answer

@ChrisGaffan How are you presenting this field in your card? Sometimes sorting can interfere with how the cards react
0
Answers

COUNT(`Room/Row Id`) gives you the number of rows with that column populated so if you have multiple rows with that same ID it will count all of them. If you want to count the IDs just one time you'll need to do a COUNT(DISTINCT `Room/Row Id`)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 
@GrantSmith COUNT(`Room/Row Id`) alone returns 764 which is accurate. It's when I add "1344 " that it spits out 12,676.
0 
@user058901 It's likely inflating the value because it's adding 1344 to every row. Try using AVG(1344) so it does not get duplicated
0 
0

@ChrisGaffan How much bigger? Is it correct if you remove DISTINCT?
0 
@MichelleH With Distinct, it returns 12,716. Without Distinct it returns the original 12,676
0 
@ChrisGaffan How are you presenting this field in your card? Sometimes sorting can interfere with how the cards react
0 
It appears that you're somehow multiplying your original number by 10 as your result of 12,676 is equal to 1344*10  764
Are you doing any aggregation with your beast mode? Can you paste your exact beast mode you're using?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 
@MichelleH @GrantSmith The sorting is what was breaking it. I removed the dimension from Sorting and it now works properly.
Thank You both.
0
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 602 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 695 Beast Mode
 43 App Studio
 39 Variables
 658 Automate
 170 Apps
 441 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 386 Distribute
 111 Domo Everywhere
 269 Scheduled Reports
 6 Software Integrations
 113 Manage
 110 Governance & Security
 8 Domo University
 30 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive