Challenge #186: Drilling down into Data Analysis

[justindavis]

Révélation

[JamesFo]

Révélation

Found this one suprisingly tricky to filter the results down - must be tired! Got there in the end.

Thanks for setting this one!

James

[RichoBsJ]

Hi! Here my solution 🙂

[alexandramannerings]

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

Révélation

[JonMcMillin]

Thanks for the challenge!

Révélation

[sprodger]

Révélation

[kat]

Révélation

[RoDO]

My solution

Révélation

[Pentacleus]

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

[lmorrell]

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

Révélation