Sep 28, 2022 11:03 AM
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!
Sep 28, 2022 11:51 AM
Hi @Mike_D_RAG ,
Welcome to Airtable Community !
I think the best option here is to use the Extension - Pivot Table , it would summarize that for you.
Sep 28, 2022 11:58 AM
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.
Sep 28, 2022 12:15 PM
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:
Sep 28, 2022 02:17 PM
Thank you Mohamed, I have tried the roll ups using linked records and it is still not the desired outcome. your second suggestion doesnt produce percentages at all.
N E 1 got a script for what I am asking for?