Forum Discussion

newbie2bi's avatar
newbie2bi
New Member
4 years ago

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI

    Perhaps, this could help you

    srting_carac = SWITCH(TRUE(), CONTAINSSTRING(Feuil1[Column1],"ABC"),"ABC", CONTAINSSTRING(Feuil1[Column1],"XYZ"),"XYZ",CONTAINSSTRING(Feuil1[Column1],"*"),"Other")