community
cancel
Showing results for 
Search instead 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.
Getting started with Designer? | Start your journey with our new Learning Path!

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.
answer.png
Asteroid

I forgot to set a timer but fun nonetheless!

Nebula

Hi @Adam_Dooley 

 

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

 

Dan

Asteroid

I thought I did attach it, whoops.  

 

Thanks @danilang 

Pulsar
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!


Capture2.PNG



Capture.PNG
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?

image.png




Pulsar
Pulsar

@EstherB47 

 

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!

Nebula

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 Certified 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.

I hope this page will not be deprecated.

Regards, Roland

Alteryx Certified Partner

Where can I download Alteryx 2019.2? The downloads.alteryx.com page states that that package cannot be downloaded because some ID field is missing. Please help me track down an update for Alteryx Designer 2019.1 to 2019.2. Of note: the Alteryx Designer can check for updates but it states that it is in fact up to date. Please elaborate when of how I can do this challenge.

 

Edit: (for anyone else wondering the same: I found it here by just bashing many hyperlinks: https://alteryx.flexnetoperations.com/flexnet/operationsportal/entitledDownloadFile.action?downloadP... YourID) Of Note: it may take several hours to complete the download as mine are still taking 1h 23m for the Rinstaller and 2h 49m for the designer 2019.2

 

Edited again: downloads failed, restarted and are once again super fast. Nearly ready to start this challenge