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 I have answered your question, please click "Yes" on my comment's option. 😊
0
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 460 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 188 Visualize
- 251 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive