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:
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: