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 #212: Draft Masters

Highlighted
8 - Asteroid

0.5 correlation between grade and pick value...

Highlighted
7 - Meteor

solved!!

Highlighted
Alteryx Partner

As usual, I'm almost certain there will be quicker ways to do this but I got the exact results so I'm pleased none the less. I'm sure @mceleavey will have a smarter way of doing it with a tool I'm yet to understand given I'm not remotely technical.

 

Enjoy the draft, everyone.

 

 

Spoiler
CHALLENGE21.png

 

 

Highlighted
6 - Meteoroid

This could definitely be done cleaner but I got there in the end.

Highlighted
Alteryx Certified Partner

Ok @Shifty , challenge accepted.

 

Actually, I think I've done this the same as everyone else perhaps with the slight difference of using the Arrange tool...

 

Spoiler
I first loaded the first input into the arrange tool, which is perfect for arranging multiple columns of the same data into a single column without having to pivot the data using transpose, then grouping into like for like records and pivoting back using the Cross-tab tool. This is fine on smal data sets but when you're looking at larger data sets then that comes with an overhead.

After that, I unioned the annual data sets and joined to the first on Pick number. The records from the annual sets that did not match are the ones to which we assign the value 2.
After that, it was a simple matter of grouping and summing the data accordingly, creating the calculation, sorting by year ascending and the calculated field descending then using a sample tool to take the first three records grouped by year:

mceleavey_0-1587668216127.png

 

mceleavey_1-1587668297817.png

 

 M.

Highlighted
Alteryx Partner

Shifty_0-1587669142956.png

:: googles "circles and triangles alteryx tool" ::

 

Highlighted
7 - Meteor

My solution 🙂 

Highlighted
8 - Asteroid
Spoiler
I was going to build a macro to fix the structure on the Draft Pick Value, but it wasn't worth the time. Brute force today!
Edit: Adding a second image to show my revised solution. Totally forgot the re-arrange tool existed until I was walking my dog last night!

Capture.PNG

Capture.PNG

 

Highlighted
5 - Atom

Same here. Getting different values for 2019 and 2015. However, it was a great challenge. 

Highlighted
6 - Meteoroid

My first time attempting the challenge:)