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
Quick and easy. Solution attached.
Spoiler
Used filter to exclude cancellations and no-shows. Formula to concatenate check-in date. Two date time tools to convert check-in and check-out from string to dates. Formula for DateTimeDiff function to get length of stay. Another filter to exclude 0s. A third Date Time to extract Month name from date. Summary to aggregate it all.
Nice and straightforward challenge this week. I'm sure I could've done this with less tools to be more efficient, but it got the job done.
Happy Hump Day!!
Derek
