grouped bar from extracted text
I Have data in a column that looks like this:
Colorado, New Mexico, Nevada
New Mexico, Florida
The column might have just one name or as many a 6 different state names separated by commas, not in any specific order.
I want to make a Grouped Bar card that will count the total for each state if it exists ANYWHERE in that string. (LIKE statement????)
Then display grouped bar with count for each state.