Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #206: Hotel Reservations

Highlighted
Alteryx Certified Partner
Spoiler
joshvbarth_0-1587055827271.png

 

Highlighted
6 - Meteoroid

My first attempt / contribution to the Weekly Challenge with Alteryx - could probably use fewer tools, but that's why I'm here, for the practice!

Highlighted
8 - Asteroid

Dont like the headers. Arrival date is after Reservation status Date wherein the latter is supposed to be the Check out date etc. Else an easy one.

Highlighted
8 - Asteroid

Nice and quick

 

JamesBills_0-1587118301623.png

 

Highlighted
6 - Meteoroid

Thanks for the challenge. I've definitely learn something new using the datetimeparse functions. But the question should've been a little specifics and it should've specify "calculate the average hotel stay and count the number of reservation....... in each month

Highlighted
Alteryx Partner

You had me with the Modern Family GIF.

Spoiler
Admittedly, this was my first experience with the DateTimeParse() formula.  Very handy!  Much better than creating a lookup table to convert month names to numbers.

Also excluded "No-show" reservations just to be sure.

mrmichae_0-1587226230989.png

 

Highlighted
7 - Meteor

WY - 206.PNG

 

My first weekly challenge after many months! - Looking forward to being more active

 

 

Highlighted
12 - Quasar
Spoiler
206_Spoiler.PNG
Highlighted
8 - Asteroid

in attach

Highlighted
6 - Meteoroid

Here's my solution :

 

Spoiler
206.PNG