Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #134: US Grand Prix Prelims - Email Dates

8 - Asteroid

My solution.  

Spoiler
Challenge_134_Spoiler.JPG
7 - Meteor

Solution attached

12 - Quasar
12 - Quasar

A bit slower than I was with challenge #134 taking 14 minutes to complete this one. Need to improve my understanding of regex as I'm certain that will be a quicker way of parsing out the dates compared to my method.

 

Spoiler
Challenge 134.JPG
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Alteryx Partner

My default for solving these kind of questions is regex hehehe. 

 

Spoiler
Capture2.PNG   

 

8 - Asteroid

nice quick little challenge - could have gone back and changed the flow to use fewer tools, but this shows my thought process...

 

Spoiler
134.JPG
Alteryx Partner
Spoiler
image.png
9 - Comet

I went a little bit beyond and found that Kenneth averaged 47 days between emails. The median worked out to 24 days.

Spoiler
WC134.png
8 - Asteroid
Spoiler
challenge_134-PP.JPG
12 - Quasar

Solution Attached.

Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
WorkflowWorkflow