Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #89: Analyzing Social Data

alexnajm
17 - Castor
17 - Castor

I decided to create a pie chart of the most common hashtags! It's not perfect, but it'll do 😊

Challenge 89 Chart.PNG

Jonny
Bólide

my solution:

 

Saqueador
Jonny_0-1624542999936.png


1. packed input files under one input tool so I could see the hashtag/filename as field.
2. created three statistics:
Tweets per hashtag

Jonny_1-1624543082268.png

 


Retweets per hashtags

Jonny_2-1624543096196.png

 


Top 10 users by number of tweets

Jonny_3-1624543123585.png
JackBurnham
Asteroide

Most used Hashtags

Laurap1228
Bólide

Here is my quick cleanup.

Saqueador
Laurap1228_0-1626998002581.png

 

I plan to add a few Alteryx reporting tools to make a few charts.

PangHC
Quasar

solution.

 

hard to think what to visualize.

 

i plan to have a chart that Number of tweet by time based on Follower, but cant find a way to show a chart like that.

 

Erin
Bola de fogo

My challenge was to calc top 10 hashtags, overall stats from the data (min, max, etc.), top 10 people with most tweets and concatenated list of their top 10 hashtags without repeats.

JoePC
Cometa

Solution Attached

phottovy
13 - Pulsar
13 - Pulsar

Ready for # 90!

JasonHu
Asteroide
Saqueador
workflow.png

Here is my submission.

Here is my solution!

 

Saqueador
I focused on data prep. I combined all inputs into one tool, parsed out all the unique hashtags, and created a list of the top 3 hashtags that were trending each day. 
Maskell_Rascal_0-1632172761395.png

 

Cheers!

Phil