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
Handle Yes/No Answers in a table
+2
+28Hey @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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.