- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 07:55 AM
I have data from an outside program that essentially has 300 questions from form submissions as columns and the rows containing Yes, No or N/A answers. I need to organize this data in a way to be able to get totals for how many yes/no for each question and come up with percentages for how often something is a yes. Thank You
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 11, 2025 04:02 AM
Hey @122!
You’ll want to create one table for Questions and one table for Submissions
On your questions table you’ll create one record per question.
On your answers table you’ll link each answer to its corresponding question (linked record field).
On your Questions table you’ll create 2 Count type fields for counting answers. Each should have different conditios. One for counting where answer is Yes; the other one for counting when answer is No.
