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

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

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)

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.