Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Yet a slightly different number of records (16322 for me)
No option to install the text mining tools for now
I get slightly different results (but very similar)
Assume it comes down to the way the data was cleaned and the set up of the sentiment analysis tool.
I have tried to create an interactive chart but couldn't change the colours to what I wanted by using split by type and not separate layers 😔
Definitely not an optimal solution but it gets to a result that I would be happy to do text analysis on. Video solution here: https://www.youtube.com/watch?v=ddJHPlmZXOQ&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=31
Submit my solution, thanks!
REGEX_Replace([body], "<div[^>]*>|<\/div>|<p>|<\/p>|<a[^>]*>|<\/a>|<noscript>|<\/noscript>|<img[^>]*>|<\/img>|<span[^>]*>|<\/span>|<ol>|<\/ol>|<li>|<\/li>|<BR \/>|\\n|\(Highlight to read\)|<strong>|<\/strong>|Spoiler|<strike>|<pre>|<\/strike>|<\/pre>|<font[^>]*>|<\/font>|<LI-EMOJI[^>]*>|<\/LI-EMOJI>", "")