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 #30: Alteryx '16 Grand Prix (Race 1, L2)

Dazzerman
11 - Bolide

That was a nice quick solution!

 

Spoiler
Challenge30.jpg
KT2
7 - Meteor
Spoiler
 
JamesCameron
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1574429592436.png
SueDonim
8 - Asteroid

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
rslopez2
8 - Asteroid

Took right at about 8 minutes

 

Spoiler
RL_Wk30.png
Nic_Morales
Alteryx
Alteryx

Solution attached

DanielLing
8 - Asteroid

Nice collection of data analysis challenges, enjoyed them.

might have gone over the ten mins!

Kakuffo
Alteryx
Alteryx

Didnt time myself

danicahui
8 - Asteroid
Spoiler
Challenge 30 2019-11-29.jpg
sachinw
8 - Asteroid

My Solution: