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.

Challenge #134: US Grand Prix Prelims - Email Dates

Alteryx
Alteryx

I know you guys are as excited as I am for another question from the Grand Prix! This one was also from the prelims for the US Grand Prix. This week, we are focusing on calculating time that has elapsed between emails, but the data need some cleansing first.

 

Congrats to our Finalists that were announced last week!

Spoiler
Capture.PNG
Alteryx Partner

Here's my solution 

Spoiler
Capture.PNG

My solution! Twinsies with speed-demon @patrick_digan... I am starting to think you have a special alarm that notifies you the second the next challenge is posted... :)

 

Spoiler
WeeklyChallenge134.JPG

Cheers,

NJ

Alteryx Partner

Here's my proposition : 

 

Spoiler
2018-09-24_17-12-46.png
Comet

Surely not the clearest way to do it but it works :)

Alteryx Certified Partner

 

Spoiler
Different approach and my datediff was figuring the days on the lesser side so had to convert from hours (datediff of hours) to days in my final formula tool. A lot of tools but this is how I logically think.

wk134.PNG

Different approach but got there!

 

Quasar

Nice little lunch time Challenge

 

Spoiler
Solution.png

 

Dan

Asteroid

While I did get to the solution, I think there is an error. @JimmyG: If you subtract the dates with time included, you get to different numbers. For example, the first one comes to 14 days instead of 15. 

 

 

Spoiler
alteryx-c134.PNG

 

Alteryx
Alteryx

@AGoyal - good catch. We actually found this during testing so we added a hint to not worry about the time.