How to calculate count of Devices as per country using beast mode ?

In above screenshot, I want Italy should show 4 Devices
Thank You!
Best Answer
-
@Priyanka check your sorting and date range. Incorrect sorting or graph by settings in the date range can cause data to not be aggregated as intended. As an exercise you can remove sorting fields and in graph by select "none"
If I solved your problem, please select "yes" above
2
Answers
-
Is # Devices a beast mode? If it's a column you can select the column in the table and under aggregation select SUM. If it's a beast mode you can wrap it in a SUM value depending on how your beast mode is written.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
# Devices, yes its beast mode - COUNT(
Order Number
) (Order Numbers are unique) how can we group Italy and will show count 4.
So I want a table in a such way that country will show total number of orders against it ,so could you please assist ?
Thank you so much for your quick response!
@ GrantSmith0 -
@Priyanka check your sorting and date range. Incorrect sorting or graph by settings in the date range can cause data to not be aggregated as intended. As an exercise you can remove sorting fields and in graph by select "none"
If I solved your problem, please select "yes" above
2
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 412 Distribute
- 120 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive