We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

# 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.

## Challenge #328: Booking a Flight? Think Twice!

8 - Asteroid

Solution attached.

I got a different answer for question #4. I don't think the sample output answer is correct with "44,777 cancelled flights". The starting input has about 94k lines of flight details, so if 50% of these flights were cancelled the airline industry would be in really big trouble :)

8 - Asteroid

My Solution

Yes, 4th solution is misleading ..seems some incorrect value

8 - Asteroid

Please find my Solutions attached. Like others have said, the Output is kinda misleading and outright wrong for the fourth solution.

Spoiler

8 - Asteroid

might even think thrice after this challenge

13 - Pulsar
Spoiler

Questions not worded great and output made things a lot more confusing, but nice, easy challenge.

8 - Asteroid

So #4 asked for the number of flights canceled in the summer of 2021. My answer was 25. I have no idea where 44,777 came from because out of 94,756 records, and there were only 1,530 cancellations. There were 73,254 flights in the summer, and I know the flights were bad but I'm pretty sure not half of the flights were canceled! That would be nuts!

Spoiler
The Prep Stage:

The Solution Stage:

16 - Nebula

Agree with everyone about Output #4 being an issue, but otherwise good!

Spoiler
8 - Asteroid

Challenge Solution

Spoiler

16 - Nebula

Solution attached.

Spoiler

9 - Comet
Spoiler

Wording is definitely misleading, have to check others workflow to notice the count is the answer, not the sum of minutes.