Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula to Pull data to Create Pie Chart from survey questions on multiple choice answers?

Topic Labels: Formulas
89 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Here is an example of what I have. Each student has 5 choices in the answers. 15 questions, 30 students and 5 choices per question. I need to create a global pie chart for the percentages answered to each question.
In the example: How often do you consider someone else’s Pain?
The answers: Very Often, Often, Sometimes, Rarely, Not at all

I need the poercentage of how many students answered Not at all or often etc
Untitled

1 Reply 1

Hi,

example:
image

single record in PData, linked to all in Tasks and all in New Table (link from ‘outer’ side, copypasting ‘total’ into whole field of both tables)
image

and the result. you can also return score total, using PData again with rollup.

image