Challenge #206: Hotel Reservations

[TobiasFitschen]

Spoiler

 

[Vladakuz]

Solution attached :)

[Sheriyalavikas]

Good

[asultanov]

Solution attached.

[alteryxokan]

Hello, 

I'm now reviewing your workflow and wanted to ask why you wanted to create an extra field for reservation_status_date

Could this be 2 field formula instead of 3? Just wanted to learn more abut your logic. Thank you

[Bren_Spill]

Spoiler

 

[Sivashankaran]

Here is my solution for Challenge #206,

1. Filtering the records for which reservations status where not canceled.

2. Creating a column named CheckIn_Date using,

[arrival_date_year] + "-"+[arrival_date_month] +"-" +[arrival_date_day_of_month]

3. Convert CheckIn_Date string column to custom date format “%Y-%B-%d”

4. Calculate Length_of_Days using, DateTimeDiff([reservation_status_date],[CheckIn_Date_Final],'days')

5. Use filter to check records which have Length of Days > 0

6. Use Aggregate functions Avg(Length_of_Stays) and Count (Reservation_ID) by grouping month in date column.

[LorraineF]

This was fun

[marienadia_uwurukundo]

challenge solution