For example we do surveys to our schools, and they have multiple choices as to how to answer the questions. We want to pull data based on how many students answered a specific way to a specific question. We created the questions as fields and sent the forms out.
So like: “How often do you come to class prepared?” and the answers are “Never” “Sometimes” or “Often” and we would like grab what % of the students answered “Never” or “Often” etc…
End result would be a pie chart that has the questions and the % of students that answered “Often” Very Often" etc…
any help pulling the data as a sum or even a percentage would be AMAZING!
Mohamed… No sir. Thre is no aspect of the pivot or pie that pulls the students answers and ties it to the questions asked giving the answers as percentages.
6 months of research and studying, I have tried alot of things. In this case, a simple answer will not work. I am looking for a script, or something of that nature.
Well the other easy way would be to convert those Single Select fields into Linked Records fields , This way you can use Rollup fields to get the data that you need.
Although this might become a bit tricky (since I assume you have multiple questions that you need this data for and not only 1 question?)
What comes to mind is the following:
IF you dont want counts and want percentages instead, then you will do the same way but with a slight difference:
Hope this helps :slightly_smiling_face: