cancel
Showing results for
Did you mean:
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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

## Challenge #171: 2019 Grand Prix US - Heat 2

Meteor

This was fun, and possibly a little easier for me than last week's challenge.  I think I knocked this out in about 6 minutes or so.

Spoiler

I ran through a bunch of sort, rank and repeat.. then a simply running total and filter gets the answer.
Asteroid

I forgot to set a timer but fun nonetheless!

Aurora

Speed will come with practice.  If you want to get credit for this challenge, attach your solution to your post.

Dan

Meteor

I thought I did attach it, whoops.

Thanks @danilang

Pulsar
Spoiler
Apparently this question is still the bane of my existence. This time because I forgot to change my Overall Rank field to a double in the Formula tool!

Pulsar

Here's a solution, co-authored with @danilang . We took turns, dropping one tool on the canvas at a time.

Spoiler
Did anyone else notice these data discrepancies? Turned out they didn't matter, and we decided to complete the exercise to see if they'd drop out -- they did.

Wonder what I would have done on stage if I noticed. Missed the Grand Prix this year. @BarnesK , @PhilipMannering , did you notice? What were your instincts?

Pulsar

That's a fun way to complete a challenge! Did you describe what you were doing along the way to each other or try to work together silently?

Fortunately, I did not notice this on stage. If I had, I probably would've gotten sidetracked from the main problem and spent too much time trying to figure out if it was okay or not. (I guess it didn't matter in the end anyway since I found another place to waste time lol.) I did notice when redoing it this morning, though, and I thought that might've been where I was going wrong until I realized I just had a wrong field type!

Aurora

Hi @BarnesK

It was a fun solving process.  We worked Independently, taking turns.

Because of the order that we dropped the tools, I noticed the discrepancy and mentioned it to @EstherB47.  She, being younger but much wiser than I, suggested to move forward.  I would have fixed the initial formula to clamp the values.

I look forward to repeating the exercise with a harder challenge

Dan

Alteryx Partner

Hi @JimmyG,

I was waiting for a link to appear on the index page (https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275) but it is still missing.

Regards, Roland

Alteryx Partner