Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #185: Amplify your Learning with Weekly Challenges!

Highlighted
7 - Meteor

Not my Favorite one.

 

Bonus didn't make much since to me.  

 

Spoiler
I did a unique and filter on the correct dates.   From there, the first question was just a summary to get the number of openings.  The second question was a summary and cross tab tool then the ABS() of Downstream-Upstream.   The final question was creating a calc to take the difference in minutes (From the Multi-Row Tool after being ordered in time series occurrence). and format it in the same way the answer was.   Taking the most openings per Day of week, month, and hour, I was getting something in September 15th ish.  The wording was a bit unclear how the are looking for an answer but oh well.  
Screen Shot 2019-10-18 at 11.57.05 AM.png
Highlighted
8 - Asteroid

Fun challenge.

Highlighted
5 - Atom

Here is my answer!

Highlighted
5 - Atom

 

Spoiler
Spoiler!

In fact, I find the answer to the bonus question a bit misleading. The outcome is the average within the grouped data (by year, month, day of the week, hour) which favours data sets with one strong year.... As is the case for 2 pm on Sundays in August, which is sampled only for one year. There are 18 combinations of month, day of the week, and hour in the data which show a larger total number of lifts than 2 pm on Sundays in August (see screenshot below).

 

Since three full years are sampled, I would rather use the total number of lifts as an indicator as when to head for Tower Bridge, or, something like an average, wheighted by the number of the day-of-the-week being sampled  in a given month (i.e. the numbers of Sundays and Mondays can be different within a given month).

 

clipboard_image_0.png

 

Highlighted
Alteryx Certified Partner

Using the DateTime Parse tool made the Bonus much simpler to get working (Custom Format: hh on days in Month)

Spoiler
clipboard_image_0.png
Highlighted
Alteryx Certified Partner

Here's my solution. It was great to meet some of you at Inspire this week!

 

Spoiler
Screenshot 2019-10-20 at 14.20.59.png
Highlighted
5 - Atom

"Inspired" by attending Inspire this week to attempt my first weekly challenge- looking forward to the next!

Highlighted
12 - Quasar
Spoiler
Challenge #185.PNG
Highlighted
Alteryx Partner

Inspire, inspired me to finish this one -thanks!!

 

Not sure how to do the spoiler picture!

 

6 - Meteoroid

Solution:

 

Spoiler
clipboard_image_0.png