Count Based on Unique Identifier
I'm very new to Domo and in particular Beastmode.
In this case, I do not have access to the dataflow behind the chart.
I'm trying to count the number of yes and no responses for each unique ID number to put into a stacked bar chart. My X-Axis is the person and the Y Axis is the total number of unique items stacked by Yes/NO. The same ID will never have a Yes and No. The response will always be the same for each ID, but the ID could be listed many times. Sample data below:
Any help would be greatly appreciated.
To get a unique count based on the ID and Person, I believe the following should work for you. Here is the BeastMode I used in testing:
And here is a screenshot of the setup/results:
This seems to capture what you're looking for. If not, please let me know how I can help further.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the thumbs up if this post helped you.1
Thank you. This worked with one exception. It is showing 1 more response that actual unique id's. Not sure why. I've actually manually counted the data and the unique id count is correct. Any ideas?0
Is it possible that you have either an ID or Person with either a leading or trailing space or some other character?
Is it 1 additional count for every unique ID or for only 1 person?0
I've exported the data to excel and used sumproduct to count unique values by id and then concatentated the id with the yes/no and the persons name. Shows 26 in the id column and 27 in the concatentated column. It has to be something in the data. I will keep trying to determine the problem.
The bottom line is the Beastmode formula worked! Thank you I will mark it approved!0
For some reason my beast mode is not recognizing the concat command. Can you screen shot what your beastmode looks like in the screen?0
- 7.6K All Categories
- 913 Connectors
- 241 Workbench
- 470 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 24 Visualize
- 194 Beast Mode
- 2K Charting
- 6 Variables
- 14 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 18 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部