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
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 874 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive