Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
16 - Nebula
16 - Nebula

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
11 - Bolide

my solution:

 

Spoiler
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
8 - Asteroid

Most used Hashtags

Laurap1228
11 - Bolide

Here is my quick cleanup.

Spoiler
Laurap1228_0-1626998002581.png

 

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

Pang_Hee_Choy
12 - 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
9 - Comet

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
9 - Comet

Solution Attached

phottovy
13 - Pulsar
13 - Pulsar

Ready for # 90!

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission.

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
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