community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #156: What Position Should You Play?

Instructional Designer
Instructional Designer

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.

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
Asteroid

My solution..  GOOAAAALLLLLLLL !!   I hope..  :-)

 

Spoiler
Challenge_156_Spoiler.JPG

 

 

Comet

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

 

Quasar
Spoiler
Challenge #156.PNG
Asteroid

Challenge Completed

Meteor

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
Alteryx Certified Partner

My solution ... finished the easy part

 

Spoiler
156.png
Asteroid

 

 

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

 

 

Alteryx Certified Partner

Solution Attached

 

Spoiler
Challenge 156 - Capture.PNGWorkflow