How can I make a pie chart that aggregates dropdown choices in a column?
I have survey results that I need to make into a chart - for example, let's say for a question where they rate something from 1-5. Ideally, in a pie chart, it would show that x% of respondents answered 4, x% of respondents answered 5, etc. But instead, each row is getting its own pie slice.
How can I make it so that it's counting each answer choice as a percentage of the whole?
thank you in advance!!!!