Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Handle Yes/No Answers in a table

706 1
cancel
Showing results for 
Search instead for 
Did you mean: 
122
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
Mike_AutomaticN
10 - Mercury
10 - Mercury

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. 

Mike, Consultant @ Automatic Nation