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 #186: Drilling down into Data Analysis

Highlighted
8 - Asteroid
Spoiler
challenge_186_solution_justindavis.PNG
Highlighted
8 - Asteroid
Spoiler
Found this one suprisingly tricky to filter the results down - must be tired! Got there in the end.

Challenge 186.PNG

 

Thanks for setting this one!

 

James

Highlighted
8 - Asteroid

Hi! Here my solution

Highlighted
Alteryx Partner

I like the number of different solutions! Representing Data Prep U with our solution. 

Spoiler
168.png
Highlighted
8 - Asteroid

Thanks for the challenge!

 

Spoiler
clipboard_image_0.png
Highlighted
8 - Asteroid
Spoiler
sprodger_1-1571839749895.png
Highlighted
12 - Quasar
Spoiler
Challenge #186.PNG
Highlighted
Alteryx Partner

My solution

 

Spoiler
challenge_186_RODO_Solution.png
Highlighted
5 - Atom

Thanks for a good presentation today on the challenge. 

 

I went back to try to solve, and did.  The one thing that I did not like was how the posted answer fabricated "Removed Date" = 7/1/2019 for those rows that did not have a Removed Date.  My solution maintains a Removed Date of Empty (null), which I feel is more accurate and might avoid misinterpretation if this was a production query.

 

This challenge also created a challenge for me, a SQL guy.  I am used to being able to join two tables and use functions and Boolean operators in my "group by" statement.  That would have made this much simpler.  So I had to find a way to split this group by into multiple steps.  I got to what I needed though.

 

This was my first time using Alteryx.  I thought it was a good exercise.  Feel free to comment.

 

Thanks

Josh

Highlighted
Alteryx Certified Partner

Awesome seeing some of the sleeker solutions once I had completed my own! Great reason that I love the weekly challenges. 

 

Spoiler
Snag_41d787.png