Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account 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 #253: Delivery Dates

almeera
8 - Asteroid

almeera_0-1671721629011.png

 

Eugenialg
7 - Meteor

Eugenialg_0-1672171094450.png

 

KORKIS3
8 - Asteroid
Spoiler
KORKIS3_0-1673386859138.png

 

Simple Solution : )

DanielG
12 - Quasar

solved

 

i seem to be hitting all the datetime formatting weekly challenges as I play catch up.  :)

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1673455897490.png

 

TyroneW
Alteryx Alumni (Retired)

Solution: 

TyroneW_0-1673472164339.png

 

 

lucysinclair62
8 - Asteroid

Solution below:

Spoiler
lucysinclair62_0-1673542184831.png

 

Jose_Flores22
8 - Asteroid

my attempt

Jasond2022
6 - Meteoroid

I didn't read through all the comments, so maybe I wasn't the only one, but I tried to change the Transit Time data type to a time to match Order date and couldn't figure out why none of the formulas I could come up with would work. Started looking at solutions and saw everyone had less tools, but similar ideas to what I originally thought. Then I saw I was over complicating things because Alteryx tends to be very complicated.

 

Anyone else? 

Buehler? Buehler?.....Buehler?

Verakso
11 - Bolide

Sweet nice challenge, but it bothers me a bit. that my result is not in the same order

Spoiler
Workflow, comparison and resultWorkflow, comparison and result
I am not getting the same order of the result, but I do get the same data,

/Verakso (ツ)