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
Decided to use Alteryx's reporting tools, as they are a definite weak spot for me. Looked at tweets and retweets per hour across the different searches
Used this one to play around with interactive charts a bit
Spoiler
Process:
- Union of all input files
- Parsed date
- Cleaned up dates
- Created date per minute (i.e. removed seconds from DateTime)
- Calculated number of tweets per minute
- Graphed number of tweets per minute (not I clipped the Y axis in the chart below to make it more legible)
- Extracted each hashtag
- Transposed data to get all hashtags in a single column
- Grouped by hashtag and date, then calculated number of uses of hashtags
- Sorted and cleaned out nulls
- Sorted by Date (asc) and Count (desc)
- Extracted top 5 hashtags per day
- Stacked Column graph of top 5 hashtags each day
- Union of all input files
- Parsed date
- Cleaned up dates
- Created date per minute (i.e. removed seconds from DateTime)
- Calculated number of tweets per minute
- Graphed number of tweets per minute (not I clipped the Y axis in the chart below to make it more legible)
- Extracted each hashtag
- Transposed data to get all hashtags in a single column
- Grouped by hashtag and date, then calculated number of uses of hashtags
- Sorted and cleaned out nulls
- Sorted by Date (asc) and Count (desc)
- Extracted top 5 hashtags per day
- Stacked Column graph of top 5 hashtags each day
