Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Challenge #212: Draft Masters

Niklas
8 - Asteroid

0.5 correlation between grade and pick value...

Chirag09goa
7 - Meteor

solved!!

Shifty
12 - Quasar

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

 

 

rfroese1
6 - Meteoroid

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

mceleavey
17 - Castor
17 - Castor

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.



Bulien

Shifty
12 - Quasar

Shifty_0-1587669142956.png

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

 

Madhuprana
7 - Meteor

My solution 🙂 

jmt214
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

 

Siddhi1993
5 - Atom

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

tavakian
7 - Meteor

My first time attempting the challenge:)