Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #225: How Long Has It Been?

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found hereThe App InterfaceThe App Interface

 

Time! Is it the fourth dimension, or a great unknown? A man-made concept or universal truth? Well we won't be solving those questions this week. Rather, we set our sights on describing the length of time between then and now!

 

For this week's challenge, create an app that calculates the time that has passed between a user-specified date and the present. The user should be able to select the units of time in which the results are displayed.

Blake
12 - Quasar

Oh man I just realized how many days I've been alive...

 

Spoiler
Blake_0-1595249019352.png

Check out my video solution below: 

Spoiler
Why shouldn't you tell secrets around a clock? 
Spoiler
Because time will tell


Aaron_Harter
11 - Bolide

Fun challenge if you have the time!

Spoiler
225.PNG
atcodedog05
22 - Nova
22 - Nova

Pretty straight forward challenge.

 

Was expecting a more tougher challenge for 225th challenge.

 

And hoping there is a badge. @AYXAcademy 

 

Spoiler
atcodedog05_0-1595249790590.png

 


 

 Cheers and Happy Analyzing : )

RWvanLeeuwen
11 - Bolide

Was considering creating many more fields, like the number of Dutch holidays and the number of workdays, but I have yet to find a complete list for this type of purpose so I kept it simple 🙂

 

Spoiler
225 workflow.jpg225 app interface.jpg
jasperlch
12 - Quasar
Spoiler
Capture.PNG
johnemery
11 - Bolide

Fun challenge problem. Not many people use analytic apps or the interface tools that often, so although this challenge was on the easier side (for me, at least), it will certainly be helpful for others.

 

Spoiler
Capture.PNG
dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1595251754419.png

 

Brando
8 - Asteroid

It's kinda sad that I'm already 8,939 days old 😞

Also this saved as a macro, but I think that's what this challenge was looking for.

phottovy
13 - Pulsar
13 - Pulsar

Fun basic app! I only allowed one unit of time but might tweak it to allow multiple items to be selected. V2 is now updated after seeing the App Interface picture in the description.

 

Also, one suggestion would be to set a default date on the "Date" Interface tool

Spoiler
225.PNG

V2:

Spoiler
Replaced the Drop Down tool with a List Box to allow for multiple selections:
225v2.PNG