Challenge #172: 2019 Grand Prix US - Heat 3

Registration for the 2019 Grand Prix Europe is NOW OPEN! If you enjoy doing the Weekly Challenges and plan to be at Inspire Europe in London, take a look at the blog to register for the Grand Prix!

The week we bring you the final heat from the Grand Prix in Nashville. Now that we have predicted how many campers to expect at our summer camp and we know which block groups are ideal for asking for donations, you need to identify which block groups to target. Like last week, give yourself 2-3 minutes to read and understand the question, then sprint your way to the finish.

Good luck and I hope to see you in the prelims of Grand Prix Europe!

3-f2t-20190613_163139_olivia_y_rycoM0inspireRYC05512.jpg

FINAL_Heat3 Question_Weekly Challenge.yxzp

Macros

Join

Spatial Analysis

Preparation

Advanced

Data Analysis

Intermediate

Transform

Spatial

Accepted answers

All comments

Kenda

Spoiler

Got tripped up at first because I only chose "Where Target Touches Universe" instead of "Where Target Touches or Intersects Universe" but eventually got it and remembered to round up!

Congrats again to @PhilipMannering for pulling through and getting that W live on stage!

172kb.yxzp

NicoleJohnson

First-thing Monday morning Grand Prix Weekly Challenge = Happy birthday to me!!! 🙂

Spoiler

Icing on the birthday cupcake? Sub-4 minutes this time!!

Image result for excited gif

Cheers!

challenge_172_NicoleJohnson.yxmd

T_Willins

Spoiler

Similar approach to @NicoleJohnson Happy Monday everyone!

I love Mondays. It's the day a new Weekly Challenge come out!

FINAL_Heat3 Question_Weekly Challenge_Solution.yxmd

RolandSchubert

Spoiler

Solved in my office. I can't even imagine to find a solution on stage ... Congratulations to all the finalists.

FINAL_Heat3_solution_rsc.yxzp

neilgallen

Make group! Hah. beautiful.

Spoiler

FINAL_Heat3 Question_Weekly Challenge_NGA Solution.yxmd

ggruccio

Chose an ugly way to get there, but it works!

challenge_172_gg_finish.yxzp

phottovy

Forced me to use some spatial tools I had not used before!

challenge_172_ph_solution.yxmd

JORGE4900

Even though I was not there, it was a very exciting final to watch--(saw the video).

Spoiler

WC_172_Jorge.yxmd

pasccout

Here is my solution... You learn something every day!!!!

Spoiler

Split by region... cool!

challenge_172_my_solution.yxmd

LordNeilLord

I'm glad I wasn't doing on stage or I would died from panic!!

Spoiler

challenge_172_LNL.yxmd

danilang

You have to admire @NicoleJohnson and @T_Willins. Striking out on their own. Blazing a new trail. Not following instructions:)

Spoiler

Unlike those rebels above, I followed the hint and used the Make Group tool. What a clever little thing it is.

Dan

Challenge_172_Solution_DL.yxmd

patrick_digan

Spoiler

FINAL_Heat3 Question_Weekly Challenge.yxzp

rtorresb16

My solution

Spoiler

challenge_172_Raul_Torres.yxmd

pjdit

My Solution.. Fun to get to use new tools, and Old tools in new ways..

Spoiler

FINAL_Heat3 Question_Weekly Challenge_PD_Solution.yxmd

NicoleJohnson

@danilang - This is the second time in a month I've realized (far too late) that the Make Groups tool could have been extremely efficient & useful. Underappreciated Alteryx tools for the win!! Well done reading the instructions - I should probably try that sometime haha. 😉

T_Willins

I'll challenge you on the not following instructions part. The hint was "You will make 5 groups", not "use the Make Groups tool". I'm not going to feel too bad if I solution like @NicoleJohnson as I was inspired to start working through the weekly challenges by watching her win the 2018 Grand Prix.

cplewis90

Reliving this question, I wish I would have tried to not use the Make Group tool (one I have never used before and was trying to learn on the spot) and think about the other spatial tools like I did here similar to @NicoleJohnson

I am definitely learning a lot from the Make Group solutions!

Spoiler

challenge_172_CL.yxzp

RichoBsJ

Hi! Here my solution 🙂

Spoiler

Thank your very much @JimmyG for this challenge! I really love spatial problems 😄

8 minutes...

challenge_172_richobsj.yxzp

DataG8

Make groups is a complex tool.

Spoiler

challenge_172_DataG8.yxzp

cgoodman

Entered for the London Grand Prix prelims and decided to time myself taking 9min 41sec. Took too long trying to solve a part where I need a unique tool but looking at others solutions others didn't need it so will review those to understand the differences, and blown away that @NicoleJohnson did it in sub-4!

Spoiler

EDIT: Worked out it's because I take the matched fields from for the right input on of the join which caused the data to duplicate and then needing unique to de-duplicate. The data duplication is what cost me the time there!