Challenge #206: Hotel Reservations

[roopmathi]

@Johnemery when I grow up , I want to Alteryx like you lol.

Thanks for this simplistic solution. I was struggling to simplify my solution i two areas: 

1. How to Parse the date from Arrival Year, Month, and day of the month using a single tool 

2. How to filter reservations that were canceled and that had a length of stay> 1 in the same formula tool

Your solution opened my eyes to how both of these could be achieved. 

Thanks, a lot. I haven't watched your Youtube video yet, but I intend to.

[Kelly5sons]

My answer to this challenge

1. Added sort by month number.  

2. Set average to 2 decimal places

[MDestra]

Challenge #206:

[Abhilasha_N]

This is my solution. I might have used quiet a number of tools, wish I learn to simplify soon by practicing. 

[Computernerd]

I think I forgot to post my solution.  So here it is.

[moszcar111]

here is mine

[BenoitC]

Done! 

Spoiler

[Desmond]

My Solution

[ananth_paltech]

Solution 

[christopher_ontkean]

Solution