Cloud Quest #43: Flight Delays

[AYXAcademy]

 

Hi Community,

We posted the solution JSON file to Cloud Quest #42. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!

Let’s dive into this week's quest!

1. Download the provided ZIP file containing your starting data and workflow files.
2. Upload Start Cloud Quest 43.json to your Alteryx One library.
3. Reconnect USA Flights 2021.csv and Airport Codes.csv to the Input Data tools in your starting workflow.

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.

 

Scenario:

Nobody likes getting stuck in an airport waiting for a delayed flight. Using the dataset USA Flights 2021.csv, which includes a random sample of flights in 2021, analyze how delays played out during the summer months (June 21 through September 22, 2021). Use the other provided datasets to complete the following:

Tasks

1. Identify the five airlines that had the most delays during this time.

2. Identify which airline had the single longest delay and the date it happened.

3. Identify the five airports with the highest number of delayed flights.

4. Count how many flights were canceled that summer.

Helpful Info

• [CRS_Dep_Time] = Scheduled Departure Time (local, hhmm format)
• [Dep_Time] = Actual Departure Time (local, hhmm format)
• [Dep_Delay] = Minutes between scheduled and actual departure. Negative numbers mean the flight left early.

Hint: Try using the DateTimeParse() function to convert flight dates to Alteryx date data.

Data source: https://www.transtats.bts.gov/DL_SelectFields.aspx?gnoyr_VQ=FGK&QO_fu146_anzr=b0-gvzr

Image: generated by Google Gemini, September 16, 2025.

 

 

Earn Cloud Quest badges:

After completing your quest, head back to your Analytics Cloud library:

• Download your workflow solution file.
• In your reply, attach both your JSON solution file and a screenshot of your workflow.
• Keep submitting—every solution gets you closer to earning more Cloud Quest badges!

 

 

Here’s to a successful quest!

- The Academy Team

Download Start File | Download Solution File

[alexnajm]

Fun challenge! Always love a travel-related quest 😊

Spoiler

[Carolyn]

Solved!

Spoiler

[Carolyn]

Dang it @alexnajm ! You were too fast and beat me (again)! :-p 

[alexnajm]

@Carolyn haha I am sure you'll beat me next time 😁

[RolandSchubert]

Spoiler

[Qiu]

It is not a fight 😁

Spoiler

[AkimasaKajitani]

My solution!

Spoiler

[RWvanLeeuwen]

Here's my solution

Spoiler

if seems the sample alone provide enough details, but I would usually filter this data within Tableau

Spoiler

[patrick_digan]

Spoiler