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
A solution to last week's challenge can be found here. 
The 2020 NFL draft will occur later this week. Yay American Football! Let's look back at data from previous drafts to find out which teams used their draft picks most efficiently.
Each year the NFL holds a draft where aspiring collegiate players are selected to play for an NFL team. The draft takes place over 7 rounds with each team selecting players based on their performance in the previous season. Selections, also known as picks, can be traded amongst teams, resulting in some teams not selecting within given rounds and others having multiple picks.
In general, the earlier a pick is made in the draft the more valuable it is (i.e., you are likely to get a more valuable player with the first pick than the 10th pick). Sometimes, a highly valued prospect does not pan out and the valuable draft pick is wasted.
For this week’s challenge, create a list of the top three teams with the highest draft efficiency for each year of the data.
First time using the Arrange tool in a long time.
Also got a difference in 2019 and 2015, not sure about the final result
Different result - but actually, I don't think there is a flaw in the logic.
@johnemery @RolandSchubert @dsmdavid @Victor_Mendes
I found the difference between the posted answer and your answers.
The posted answer treats the new efficiency table as a string and which leads to the list being sorted incorrectly.
posted
what we got - notice field type difference
posted
what we got
This is a good lesson in paying attention to your metadata/field types!
The attached workflow shows how both answers can be reached.
Get a slightly different answer that is killing me..... will keep looking
Update.....all good with the new start data 🙂
