Forum Discussion
Solved
pie chart extracted values
I have a dataset where each row is a survey response. In one of the columns, it is an answer to a question. Which the users can select more than one option, that is currently sepated by a semi-column...
When you do the split, in the advanced options you should be able to split into rows:
The result should look like:
Now if you create a pie chart it should give you what you are looking for:
Pie chart will always aggregate the data on category level. So when you put Answer into Pie chart, it will count the number of Answers for different colors.
In your scenario, if you want to analysis data on each survey level, it's better to use other type of chart, like Column chart. You can put Survey on X-axis, and put Answer on Legend. Then use Count of Answers as Value.
Regards,