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.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 283 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 566 Datasets
 2K Magic ETL
 3.4K Visualize
 2.3K Charting
 596 Beast Mode
 13 App Studio
 29 Variables
 594 Automate
 148 Apps
 417 APIs & Domo Developer
 28 Workflows
 1 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 362 Distribute
 99 Domo Everywhere
 261 Scheduled Reports
 2 Software Integrations
 97 Manage
 94 Governance & Security
 14 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive