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
Alteryx

A solution to last week's challenge can be found here

 

Using the provided dataset, calculate the average hotel stay and count the number of hotel reservation IDs for all hotel reservations that were not canceled and at least one day in length.

 

hotel_lobby.gif

Source: GIPHY

 

 

Highlighted
Alteryx Partner

Fun, quick challenge.

 

Spoiler
Capture.PNG

 

I put together a solution video here: https://youtu.be/W3tJ0XeLlzk 

206] I Can Alteryx That: Hotel Reservations In this edition of I Can Alteryx That, we walk you through a solution to Alteryx weekly challenge #9. View the c...
Highlighted
Alteryx Partner

Definitely could have done this in less tools but luckily Alteryx doesn't charge us by the tool. 

 

Spoiler
206.jpg
Spoiler
Check out my video solution here 

 

Download a Free Trial of Alteryx! https://tinyurl.com/rns9x3k Join us while we build our solution for Alteryx Weekly Challenge #206! "Using the provided data...
Highlighted
Alteryx Partner

Very nice challenge!

 

Spoiler
206.PNG

 

 

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Capture.png
Highlighted
Alteryx Certified Partner

Nice quick challenge

Spoiler
Would have been nice to have the monthly avg named in the workflow

Challenge 206.png
Highlighted
15 - Aurora
15 - Aurora
Spoiler
patrick_digan_0-1583773083019.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution.

Spoiler
09-03-_2020_17-56-07.png
Highlighted
12 - Quasar

My solution

Spoiler
Workflow 206.png

 

Highlighted
8 - Asteroid
Spoiler
challenge_206.PNG