Hello, I have a field in which each row contains a comma delimited list of strings. I'm trying to find a way to display how often each string appears in the dataset. For example, the column might be "City":
Row 1 | New York,Boston,San Francisco
Row 2 | Boston
Row 3 | New York,San Diego
Row 4 | New York,Topeka
I like to create some data display that shows New York:3, Boston:2, San Francisco:1, San Diego:1, Topeka:1.
A regular bar graph doesn't recognize the comma and treats each unique string including the commas as a separate entry.
I can split the field into multiple, City1, City2, City3, etc, but I don't know of a data display that looks into multiple columns.
Any advice is appreciated, thank you.