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!
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:
Create a new Linked Record field - Create New Table (its empty for now)
Using Automations, you will create a simple expression in the newly linked field, change the answer from “Never” to “How often do you come to class prepared? - Never” which will then be linked to the new table you created
In this new table, you can then use Rollups to get the counts
IF you dont want counts and want percentages instead, then you will do the same way but with a slight difference:
Each Question will then become a its own Linked Record (without adding the answer to the question name)
In the newly created table you need a separate field for each question and possible answer (so the field will become “How often do you come to class prepared? - Never” , using conditional Rollups, count the number of students that made that answer
Create a Count field to count all the linked records (total number of students answered that question, whatever the answer is)
Back to the field in Step 2, using a simple formula you can get the percentage