Hi Guys,
Asking the community for help, I've a coloumn which has inconsitent data however it has keywords which i'll be using in the "cards" for visualization such as "ABC" and "XYZ". So when I click on the card "ABC" the "clustered bar chart" should change according to the data and show the trend.
I was thinking to seperate the column with all "ABC" in one column and "XYZ" in another" however I am finding it impossible to do it as has 20k+ rows and too many words/letter/delimiters in between "ABC" and "XYZ". Sample data is below
Can you guys help please? Any help is greatly appreciated.
Margins
| ABC |
| 10days ABC |
| XYZ |
| 64 minutes ABC |
| Remote work |
| Internal Job ABC |
| External Job XYZ |
| ABC half 2020 |
| New postpaid work |
