So Ive got a manager performance survey form. When employees answer the questions (all boolean true/false) the question field is either checked or unchecked. I've got 25 questions, and 25 fields. (plus the primary field, which is the surveyee's name)
Now I want to view the results in some meaningful way. A nice a easy way to see if people generally approve of the manager. But its like the whole system is set up to reference records, not fields. When I go to set it up I get the person's name (anonymous#1 etc) in the x axis and the questions in the y axis. I want questions in the x axis and the sum of true responses in the y axis.
So how do I do this? I need a new table where each question is a record? But the form won't populate it properly right? What am I missing here?