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

TobiasFitschen
8 - Asteroid
Spoiler
Challenge_206.png

Vladakuz
6 - Meteoroid

Solution attached :)

Sheriyalavikas
6 - Meteoroid

Good

asultanov
8 - Asteroid

Solution attached.

alteryxokan
6 - Meteoroid

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
11 - Bolide
Spoiler
Weekly Challenge 206.PNG

Sivashankaran
7 - Meteor

Here is my solution for Challenge #206,

Sivashankaran_0-1706958769143.png

 

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

 

  1. Creating a column named CheckIn_Date using,

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

 

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

 

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

 

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

 

  1. Use Aggregate functions Avg(Length_of_Stays) and Count (Reservation_ID) by grouping month in date column.
danbostrom
8 - Asteroid

 

 

LorraineF
7 - Meteor

This was fun

marienadia_uwurukundo
6 - Meteoroid

challenge solution