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 Partner

Hi

 

Here's my solution

 

Spoiler
Capture d’écran 2020-04-23 à 21.55.19.png

Cheers

Amr 

Highlighted
Alteryx Certified Partner

.

Highlighted
8 - Asteroid

Although the results may be reproduced, there are 3 tiny ambiguities or at least hidden assumptions.

1. It is mentioned that the duration of stay shall be greater or equal to 1 days. Instead of providing the check-out date, the reservation-status date is used. But sure, if the reservation status is changed to "check-out", the date is the check-out date. Still, this may be made more clear.

2. The reservation status contain three different states, "checked-out", "canceled" and "no show". For the "no show" reservation, the status date seem to be the same as arrival date which thus will be filtered out by setting stay duration >= 0. Still, it may be better to set status filter for "checked-out".

3. The reservations are counted by month name where records of three years have been included. This may make sense, if seasonal average shall be calculated. Still, more precise requirements may be more transparent. 

Spoiler
LiD_0-1587910040747.png

 

Highlighted
8 - Asteroid

Nice one

 

Spoiler
image.png
Highlighted
8 - Asteroid
Spoiler
JunePark_0-1588412369714.png

 

Highlighted
8 - Asteroid
Spoiler
Solution attached

balajilolla_0-1588513973098.png

 

Highlighted
12 - Quasar
12 - Quasar

nice, quick, helpful

Spoiler
jarrod_0-1588961053691.png

 

#SnakingMyWayThruChallenges

Highlighted
7 - Meteor
Spoiler
Solution
Highlighted
Alteryx
Alteryx

A bit of a struggle with the Date manipulation but got there in the end, great challenge!

Highlighted
7 - Meteor

Spoiler