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 #206: Hotel Reservations

rustyvasu
7 - Meteor

Challenge #206: Hotel Reservations

 

Hint - don't get fooled by the week 😛

shock7772
6 - Meteoroid

Thank you for the challenge.  

simbert
8 - Asteroid

Nice quick and simple challenge!

Spoiler
simbert_0-1596542148512.png

 

paulfound
11 - Bolide
Spoiler
PaulFound_0-1596706135244.png

3 tools, i wonder can I do it with 2?

PaulFound_1-1596706414415.png

Yes I can. 2 tools! 🙂 

 

AnaisComyn
9 - Comet

Finish ! 

SueDonim
8 - Asteroid

Been away from the challenges (and from Alteryx) for about 6 months working on COVID-19 stuff.  Man, am I rusty.  This took waaayyyyy too long as I tried to dust off the old synapses.

 

 

Spoiler
SueDonim_0-1597651525466.png

Process
- Convert arrival data to date
- Took additional step to convert with Date-Time tool
- Filtered out Canceled reservations (could have combined both filters)
- Calculated length of stay
- Filtered out reservations = 0 (the love hotel reservations)
- Summary tool to count reservations and average length of stay, grouped by month

Nice to be back

 

Bajenola
5 - Atom

Really nice challenge - perfect for beginners

Spoiler
Bajenola_0-1597760943075.png
Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Interesting one. I could minimize the number of tools that I have used but I think it works good so I will keep it as it is.

 

Spoiler
challenge_206_Emil_Kos.png
JoePC
9 - Comet

Solution Attached

Sashikumar
8 - Asteroid

Its a Good one.ch206.PNG