Breakdown of Yes or No Values
I am looking to create a graph or table that shows a breakdown of who answered yes and who answered no in a specific state.
E.x. in GA 100 people took the survey, 45 answered “Yes” and 55 answered “No”
in FL 50 people took the survey, 20 answered “Yes” and 30 answered “No”
What graph/table would you use to display this in Domo? When I try to show this in a table it shows the full count and not the yes/no counts.
My column in labeled “YesOrNo”
Thank you!
Answers
-
@DataLawton I'd suggest using a Pivot Table card with State in the rows, YesOrNo in the columns, and count of YesOrNo (or any other populated field) in the values.
0 -
Another option would to be to create a Beast Mode that counts Yes and No anwers and allows you to then count them according to the criteria of the filters on the card. Something to the effect of:
CASE WHEN `YesOrNo` = ‘Yes’ THEN COUNT(`YesOrNo`)
WHEN `YesOrNo` = ‘No" THEN COUNT(`YesOrNo`)
ELSE 0If this a suggestion above helps the customer resolve the issue on their end, please provide the outcome of this case for addressing any future issues that may arise.
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
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 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
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive