How to set up survey answers for a chart?
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?
Accepted Solutions
It depends on what exactly you'd like to see in terms of charting, really. Based on that, you'd have to update your data so that it could fit into that display. Do you have an idea of what you'd like to see as charts?
If it helps, with the way your data's set up now, you could have one graph per question in an Interface like so:
It depends on what exactly you'd like to see in terms of charting, really. Based on that, you'd have to update your data so that it could fit into that display. Do you have an idea of what you'd like to see as charts?
If it helps, with the way your data's set up now, you could have one graph per question in an Interface like so:
