Help

How to set up survey answers for a chart?

Solved
Jump to Solution
933 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

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)

Aaron_Hess_0-1680812645253.png

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?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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:

Screenshot 2023-04-07 at 5.22.51 PM.png

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

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:

Screenshot 2023-04-07 at 5.22.51 PM.png