Forum Discussion

the_kent's avatar
the_kent
New Member
5 years ago

Need help figuring out a tricky WordCloud visualisation!

What I'm trying to achieve: Use the WordCloud graph add-on to visualise the relative occurance of keywords and highlight them BASED on the entity who has the largest occurance of said keyword.

 

Data sample:

CompanyKey words
Company AApple, Orange, Banana
Company BApple, Banana, Orange
Company COrange, Apple
Company AOrange
Company BApple

 

Giving context to the data above:

  • Company A is associated with Apple, Orange and Banana in Line 1- however, across the rest of the data you'll see that Company A has been associated with Orange again. So, a total of 2 times
  • While at the same time Company B & C has been associated with Orange as well, but only once each
  • Same case with Company B and Orange
  • Banana has an been mentioned lesser AND there's no difference between how many times it's been mentioned by either company A/B

 

The output I want in the WordCloud:

  • A wordcloud where Orange & Apple are at the same size given that they are the most repeated term in the dataset - BUT it takes a data colour associated with Company A and Company B respectively as they are most associated with those terms (something like below)

 

Is this possible with either Microsoft's WordCloud viz add-in (preferably) or anyone else's?

Understand this is a bit complex and possibly niche, but happy to change tracks to another visualisation which fits into 'What I'm trying to achieve' above!