We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Quick and easy. Solution attached.
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.