Sort Table by Field Count
Hi,
I have a list of locations in one column with a list of attributes in the second column. I need to count the number of locations attributed to each attribute in a table chart. How can i create this simple result? I haven't had accurate results using COUNT functionality.
thanks!
Best Answer
-
I'm not sure if I am understanding well what you are trying to do but, you could do a beastmode Count(Distinct `Location`)
then in your table , use the 'List of Attributes Field' as the first column in your table and bring the beastmode to the second column .... this will give you the name of the attribute and the distinct count of locations the attribute is present in
is that what you are trying to do ?
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Answers
-
I'm not sure if I am understanding well what you are trying to do but, you could do a beastmode Count(Distinct `Location`)
then in your table , use the 'List of Attributes Field' as the first column in your table and bring the beastmode to the second column .... this will give you the name of the attribute and the distinct count of locations the attribute is present in
is that what you are trying to do ?
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Thanks! That totally worked I was counting on the wrong field...oops.
1
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
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive