We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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

11 - Bolide
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:

10 - Fireball

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

Spoiler
8 - Asteroid

Challenge Solution

Spoiler

15 - Aurora

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.