Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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: