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 #156: What Position Should You Play?

Highlighted
Moderator
Moderator

Weekly Challenge #156.PNG

Last week's solution can be found here

 

*Whistle Sound*

 

Soccer, Football, Fußball, whatever you call it, it’s the world’s game. This week’s challenge uses a dataset from the popular game franchise Fifa 18, which contains players from across the globe. In the game, each player is assigned a score for each attribute category, a preferred position, and an overall rating from 0-99. The rating is calculated by multiplying a player’s scores by coefficients for various attributes which are most critical to the position he plays. The score is rounded to the nearest whole number (e.g. 1.5-2.49 = 2).

 

Use the Attribute References table to calculate each player’s overall rating at each position. All relevant Attribute References should be used when calculating a rating for a position. *This is a simplified version of the positional calculations which does not factor in chemistry, international ratings, and other in-game factors. Results will not match the Overall Rating in the dataset.

 

For a tougher challenge, recreate the attribute reference table from the Rating Coefficients list. (note that the sweeper GK has the same attributes as a standard GK in addition to the unique sweeper coefficients). If you want to factor in the basic chemistry and International Reputation into the calculations, use the Int Rep table and apply a +5 boost to the categories listed in the Basic Chemistry table. *These calculations will not match the actual Overall Rating as some in-game factors are not included.

Highlighted
16 - Nebula
16 - Nebula
Spoiler
I went with the basic challenge today. I think transposing and then crosstabbing back should do it. I didn't worry about field names (or checking my answer very carefully!).
Capture.PNG
Highlighted
8 - Asteroid

My solution..  GOOAAAALLLLLLLL !!   I hope..  🙂

 

Spoiler
Challenge_156_Spoiler.JPG

 

 

Highlighted
The Force

I don't think I would play Ronaldo at GK. I went for the easy solution first and then the hard solution. I am not sure if I added the adjustments correctly, but I think I did. 

Spoiler
Challenge 156.PNGChallenge 156 - h.PNG

 

Highlighted
12 - Quasar
Spoiler
Challenge #156.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Highlighted
8 - Asteroid

Here is my solution. I attempted to do the optional part as well. Not sure if the Chemistry and International Rating sections are completely correct though. Thanks for the challenge 🙂

 

Spoiler
Challenge156_1.pngChallenge156_2.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution ... finished the easy part

 

Spoiler
156.png
Highlighted
Nebuchadnezzar Operator

 

 

My results are off due to rounding, but I like my approach.  It parses the field names and applies the rounding at the level described in the instructions.  Wish this was a basketball challenge as I could use the help filling out my bracket!

Spoiler
 Workflow 156.GIF

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Solution Attached

 

Spoiler
WorkflowWorkflow