Forum Discussion
pie chart extracted values
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:
One of many options is you can right-click on the "Answer" column in the Query Editor and "Split Column -> By Delimiter...". In the "Advanced Options" split into "Rows". Make sure you Trim the column to remove the leading spaces. The resulting dataset should work well with the pie chart.
Split column is disabled on this column. Right now each row redners in Query Editor as "[List]".
I can extract values and do as 'colon'. Then Ican split. But it creates a new column with ".1" and ".2". I'm guessing if there are more mutliple selections you'd get more of these too.
Then when I try to use both columns in the pie chart. I drag both columns onto legend and both as counts onto values. but as not all columns have values, it shows a count on some blank. If I try an do an advanced filter. ANd "is not blank" it removes rows from pie chart.
How do I do this properly so it shows all?
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: