Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #30: Alteryx '16 Grand Prix (Race 1, L2)

Highlighted
11 - Bolide

That was a nice quick solution!

 

Spoiler
Challenge30.jpg
Highlighted
7 - Meteor
Spoiler
 
Highlighted
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1574429592436.png
Highlighted
Alteryx Partner

Going back to finish up a handful of Beginner challenges I had skipped.  I was more like 15 minutes, but not too bad especially since not wearing my game face.

 

Spoiler
Process:
- Youngest team
  -- Group by Fantasy Team
  -- Average age
  -- Sort
  -- Select first record
- Lowest average pitcher rank
  -- Group by Fantasy Team
  -- Average pitcher rank
  -- Sort
  -- Select first record
- Pearson coefficient
  -- Pearson tool - select 2015 team rank and hitter rank
- Table
  -- Summarise tool
    -- Group by Fantasy Team and Position
    -- Count Players
    -- First 2015 Team Rank
    -- Count Home Runs (at player level)
    -- Count Wins (at player level)
  -- Transpose on Fantasy Team / Columns are Position / Values are Sum of Count
  -- Summarise tool
    -- Group by Fantasy Team
    -- First of 2015 Team Rank
    -- Sum Home Runs (at team level)
    -- Sum Wins (at team level)
  -- Sort

MySolution.PNG
Highlighted
8 - Asteroid

Took right at about 8 minutes

 

Spoiler
RL_Wk30.png
Alteryx
Alteryx

Solution attached

Highlighted
Alteryx Partner

Nice collection of data analysis challenges, enjoyed them.

might have gone over the ten mins!

Highlighted
Alteryx
Alteryx

Didnt time myself

Highlighted
8 - Asteroid
Spoiler
Challenge 30 2019-11-29.jpg
Highlighted
8 - Asteroid

My Solution: