The Inspire Cyber Monday promo has been extended to Dec. 1! This offer is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes.
alteryx Community

# Weekly Challenge

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.

## Challenge #206: Hotel Reservations

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.

Source: GIPHY

The solution file for this challenge was updated on June 24. 2022.

11 - Bolide

Fun, quick challenge.

Spoiler

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 challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-206-Hotel-Reservations/m-p/539029/highlight/false#M37393 Follow us
12 - Quasar

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

Spoiler
Spoiler
Check out my video solution here

Download a Free Trial of Alteryx! https://tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #206! "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
11 - Bolide

Very nice challenge!

Spoiler

16 - Nebula
Spoiler
15 - Aurora

Nice quick challenge

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

17 - Castor
Spoiler

16 - Nebula

My solution.

Spoiler
14 - Magnetar

My solution

Spoiler

10 - Fireball
Spoiler