Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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?

alamec
7 - Meteor

Attached is my solution. 

 

What is interesting about this is that when you use the datetimediff formula and choose conveying the result in years it can show you 0 (In case you specify a range below one year). In most cases in real life you might need to need to show the real value of the number instead of 0. (Example: 0.8 years) 

 

I think that will require manual conversion using the formula tool. 

 

Just wanted to say what is on my mind 😂

 

 

 

rcarog
8 - Asteroid

Solution attached.

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution! Boy time flies when you're using Alteryx... 😉

 

Spoiler
Challenge225App.JPGChallenge225Results.JPGWeeklyChallenge225.JPG

   

 Cheers!

NJ

hbraunius
8 - Asteroid

My solution attached.

WernerE
8 - Asteroid
Spoiler
Screenshot_3.jpg

Was fun to build and shorter than my first attempt. 

 

 

glenperes
8 - Asteroid

Solution:

Spoiler
225.JPG
apathetichell
18 - Pollux

I used way too many detours and check boxes...

danilang
19 - Altair
19 - Altair

We're for a good time, not a long time!

 

Spoiler
danilang_0-1622287404777.png

 

 

Dan 

AndrewS
11 - Bolide

#225

Spoiler
225.PNG
Hitch
8 - Asteroid

Here's my attempt