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!

11 - Bolide

Ok, I tried all sorts of combinations to try and manipulate an answer to match #4, I quit trying to match and just answered the question as it appeared to be written.

Spoiler

8 - Asteroid
Spoiler
Solution Attached

8 - Asteroid
Spoiler

I matched my output values as "Counts" due to Question 1 and 3 showing data for counts, but the solution output's headers called out minutes.

I created two outputs for question 4, one with all flight cancelations for the originally included dataset and another that only included the joined data, both do not match the Question 4 output of 44,777.

7 - Meteor

I have to admit, I found this Challenge quite confusing, espacially because the solution didn't really match the questions.

Tried to replicate as much as possible the solution, but I have to mention that the solution output has the number of flights delayed by airline (Q1) and by Airport (Q3) not the total number of minutes. I also wondered if the cancelled flights should have been removed from the lot of delayed flights to answer these two questions. For Q4, as mentioned by others, the solution doesn't narrow down the cancelled flights to the summer period, has way more flights in there.

All in all a nice little challenge, I always enjoy analysing flight related data 🙂

Spoiler

8 - Asteroid

My take on the solution. Some variations on the output and confused on counts vs sum of minutes.

Spoiler

11 - Bolide

Just a suggestion: Please validate the grammar, phrasing of the question(s), outputs, etc. before posting a weekly challenge.

I believe the wording and outputs are confusing many people and not generating a learning experience.

Spoiler
7 - Meteor

Error....

7 - Meteor

Same Tools Different Solution

8 - Asteroid

7 - Meteor
Spoiler
Workflow Diagram

Here is my Solution