Counting number of elements in a comma seperated column in Tableau

Question

What do I want?

Count the number of the genre in the data set.

Sample genre from the dataset:

How can I create a similar visualization using Tableau?

Answer 1

If you have access to the database, then take the dump of data in a excel. Split the data by comma(,) and then create a individual column for every word in the genre column. Now take the excel as a source to the tableau, In tableau pivot the splitted columns of Genre. Go to sheet in the tableau, place the pivot field values in rows and count of pivot field values as measures.

Finally, you will be able to see the desired result.