I have a survey that I have customers fill in.
once inputted intot the computer, is there a way to gather and calculate the information?
i.e
Excellent - 28%
Good - 56%
Poor - 26%
Either in a view or something that can show it.
Thanks in advance
Subject: One way.
Here’s one way.
It doesn’t do the %age, you have to do it manually, but it does provide the values you need.
A question, for example, has 5 responses, ranging from 1 (best) to 5 (worst). Build a view to hold the documents with the first column of the view displaying ALL responses (show value as total). The second column will display ONLY responses with a 1 (again, show value as total), the next column with a 2, etc.
You end up with a view that looks like this…
Column Title - Q1 Q1_1 Q1_2 Q1_3 etc
Values - 60 10 20 20 etc
Hope this will help.
Subject: RE: One way.
Oh, pshaw. You can, too, display the percentage in a view. Select “average per document” or “average per category” (depending how the view is organized) in the column totals setting, and format the column to display numbers as a percentage. Hide detail values. The column formula would be, for instance:
Answer1 = “1”
to show the percentage of documents that had “1” in the Answer1 field – and so on for the subsequent columns.
However, there’s a problem with doing this for a long survey – since it takes multiple columns for each question, you would end up with a heck of a lot of columns, and an awkward display – can’t really print it very well.
It might be better to use a categorized view with a complicated column formula, e.g.
(“Features\” + Answer1)
: (“Name Recognition\” + Answer2)
: (“Snarkiness\” + Answer3)
…
: (“Overall Happy Face Factor\” + Answer57)
Put a number column before the categorized column – the formula can just be 0 – and use the column totals to show “percentage of all documents”. Now you can expand any main category (“Snarkiness”) and see what percentage of responses were each of the different possible answers. Note, however, that any values nobody selected will not display a 0% – they just won’t be listed.
Or, you can use programmatically generated rich text to create a report as described in the “Programming Rich Text” chapter of this Redbook.
Subject: Oh pshaw!!
The example, indicates, the calculation is done manually. No where does it say, it can’t be done.
Subject: RE: Oh pshaw!!
How would you go about it then?
I have 10 questions, all with Excellent, Good, Bad and I want to calculate how many Excellents, goods and bads are for each question
Subject: RE: One way.
Thanks for your help you two, I will try this now