Challenge #134: US Grand Prix Prelims - Email Dates

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!

challenge_134_start_file.yxmd

Preparation

Intermediate

Predictive

Accepted answers

All comments

patrick_digan

Spoiler

challenge_134_start_file.yxmd

George_Walker

Here's my solution

Spoiler

challenge_133_solution_file.yxmd

NicoleJohnson

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

Cheers,

challenge_134_NicoleJohnson.yxmd

Julien_B

Here's my proposition :

Spoiler

challenge_134_solution_file.yxmd

Ladarthure

Surely not the clearest way to do it but it works

challenge_134_start_file.yxmd

ckings

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.

Different approach but got there!

challenge_134_CAK.yxmd

danilang

Nice little lunch time Challenge

Spoiler

Dan

challenge_134_solution_DL.yxmd

AGoyal

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

challenge_134_start_file.yxmd

JimmyG

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

OldDogNewTricks

Fun, quick one.

Spoiler

challenge_134_completed.yxmd

sh0kat

Spoiler

challenge_134_Solution_Shokat.yxmd

OldDogNewTricks

Oops...posted in the wrong challenge thread.

DavidP

My solution

challenge_134_DavidP.yxmd

kat

Spoiler

So excited, but also extremely intimated to face the big stage in a few weeks.
Challenge #134.PNG

Challenge #134.yxmd

KOBoyle

Solution attached. Attempted first to parse with regex, but couldn't get the syntax right. It was dropping the first digit. For the sake of speed, I switched to a substring formula, and then went back and fixed the regex.

Spoiler

challenge_134_solution_KO.yxmd

Aidan_K

Here's my Solution

challenge_134_AidanKing.yxmd

Wouter

My solution:

Spoiler

challenge_134_solution_WK.yxmd

clant

Here is my solution. Probably not the best regex but it works!

Spoiler

challenge_134_fin_file_CL.yxmd

ZenonH

This is my first week of using Alteryx, as well as my first weekly challenge. Any advice on simplifying or cleaning up my workflow would be appreciated.

Spoiler

challenge_134_ZH_Completed.yxmd

ch12345

This type of challenge highlights how using the 'starts with' formula or regex can simplify the whole analysis:

Spoiler

challenge_134_start_file CH.yxmd

unknown

CE challenge_134_start_file.yxmd

Ukashi

My reply

Spoiler

challenge_134_Ukashi Solution.yxmd

lminors

Enjoyable trying to make this nice and succinct.

Spoiler

challenge_134_LMsolution.yxmd

KyleLarsen

challenge_134_solved.yxmd

ponraj

Here is my solution.

Workflow

challenge_134_Solution.yxmd

datatim

Here is my solution for this week.

Spoiler

challenge_134_solution_datatim.yxmd

JimmyG

Welcome, @ZenonH! The most important thing is getting the right answer. My advice is to look at how some of the others solve the problem - that should give you a good idea of alternate solutions and you may approach it differently next time.

neilgallen

the magic of regex...

Spoiler

challenge_134_NGA Solution.yxmd

ggruccio

Monday got away from me so here it is on Tuesday!

challenge_134_gg_finish.yxmd

pjdit

My solution.

Spoiler

challenge_134_PD_Solution.yxmd

GarthG

Solution attached

challenge_134_GG.yxmd

cgoodman

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_start_file_solution.yxmd

SeanAdams

This was an interesting challenge - because if you back-convert to Zulu time (GMT) you get a different answer

Spoiler

challenge_134_SeanAdams.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703