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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive