Trend Analysis
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