Challenge #10: Date Time Calculations

Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge #09 is HERE. For this challenge let’s look at the date and time functions in Alteryx.

The use case:
A distribution center receives a package. At the point of receipt, the package is scanned and a timestamp is captured for arrival date/time. The company is trying to reduce the amount of time the package is at its facility and as a result is trying to analyze how long packages remain at the facility.

The objective for this challenge is to calculate the delta between arrival date/time and the Time_Now field (this field has the date/time of the creation of this challenge and will be changing as time goes on). Create a unique field for Days, Hours, Minutes and Seconds.

We have listed this as an intermediate exercise and I expect it will go very quickly for many of you. Let us know what you think, we are looking forward to hearing your feedback.

UPDATE 2/1/2016

You can find the solution below.

challenge_10_start_file.yxmd

challenge_10_solution.yxmd

Preparation

Data Analysis

Intermediate

Core

Accepted answers

All comments

steven4320555

This is straight forward, and good to browse through some functions in Alteryx.

Spoiler

Note, the suggested function for the data type is cool and helpful.

challenge_10_solution-Steven.yxmd

ryan_fitzgerald

Solution

challenge_10_RF Solution.yxmd

grossal

Time to work on these challenges!

Spoiler

One Tool Story 😃

challenge_10_grossal.yxmd

igorp

Spoiler

I learned Mod function thanks to this challenge 🙂

10_igorp.yxmd

dpencheva

Here is my solution. Probably is very similar to the rest. It is only with the Formula tool. ; )

challenge_10_solution_file.yxmd

chrisvg27

Solution

Spoiler

Solution included using the timediff formula, breaking out each time segment and subtracting the converted time each time

joshvbarth

Spoiler

challenge_10_solution_joshvbarth.yxmd

mark007

Done

challenge_10_start_file-Mark.yxmd

Bernhardt03

My solution.

challenge_10_MySolution.yxmd

JeremyGonzva

My solution

challenge_10_start_file.yxmd

Himanshu_1984

Hi,

Here is my Solution.

challenge_10_Solution_Himanshu_file.yxmd

Sudha8990AI

Interesting and learned some maths after long time 🙂

10_Solution.yxmd

WC_10.pdf

Normster

Thanks for that, Alex. I noticed the difference too but didn't think to look for differences in the original data. I spent some time trying to sort it out. Even did manual calculations to check my work.

Challenge 010 Workflow.yxmd

Chirag09goa

Solved with one tool and multiple formula

challenge_10_Solution.yxmd

seinchyiwoo

learnt a very nice trick using mod in this exercise:

Spoiler

challenge_10_.yxzp

cc000072

Here is my solution

Spoiler

WeeklyChallenge_Ryohei_10.yxmd

Sylvana

My solution

challenge_10_solution_sylvana.yxmd

VenkateshJeyaraj

The trickiest part to me is finding the difference then using the mod function to get the hours,mins,secs: well, i used the below formula to achieve the result.

Mod(tonumber(DateTimeDiff([Time_Now],[TIMESTAMP],'hours')),24)

challenge_10_Date_Time_Difference.yxmd

Lucatelli

Please find attached my solution.

challenge_10_start_file_solution_Lucatelli.yxmd

cody_rush

Spoiler

challenge_10_done.yxmd

FredNajjar

Spoiler

challenge_10_start_file (1).yxmd

Ben_Jeffreys

My submission

challenge_10_submission.yxmd

Chiaroscuro

Hi! I'm here again to share my solution.

This challenge is quite challenging though if you base on the data that were in the start file and solution file.

I was tricked! I thought my solution was wrong because of the 41 seconds interval with the given solution.

When I checked again and again, the given values were not the same. Haha!

So... yep, my solution is correct. I almost doubted myself.

Here's a preview of my solution. I only used the Formula Tool in generating the solution.

Spoiler

Have a nice day! 🙂

010_Weekly Challenge_ABBI.yxmd

jarrod

starting to learn that referencing columns in Python Dataframes is as simple as df['column_name'] (case sensitive!!!) that's a nice part about alteryx is that it isn't natively case sensitive.