Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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.

SUBMIT YOUR IDEA

Challenge #328: Booking a Flight? Think Twice!

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1658219011834.png

 

I could not match the answer to #4 question.

RWvanLeeuwen
11 - Bolide

I always hope for the best when joining fields I don't know, but in this case it worked out jolly well

Spoiler
328.png

 

FloSchoch
7 - Meteor

I'm a little confused...
How can a flight be canceled and still depart?

I guess those 39 records are wrong in the dataset?!?

 

FloSchoch_1-1658232591468.png

 

I'm not finished by now because i always get confused by inconsistent inputs 😅

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
328.png

Different results, because I didn't include delays for cancelled flights in count.

RobertMika
7 - Meteor

Here we go

MilindG
12 - Quasar
Spoiler
MilindG_0-1658238333256.png

 

phottovy
13 - Pulsar
13 - Pulsar

Never been more proud to be from Denver! 

Clifford_Coon
11 - Bolide

Solution Attached:

 

Notes:

1. Results indicate total minutes, but in fact the results are total number of delays

2. The results include cancelations (where a positive delay in minutes is given), rather than treating cancelations as a distinct item. Given that logic all cancelations could be included (infinite minutes delay)

3. Total number of flights canceled result seems to be an incorrect value

ARussell34
8 - Asteroid

I just wanted to point out that the counts for part 1 and 3 were for total occurrences and not total delayed minutes. Additionally, part 4 I have total number of cancelations for the whole year of 2021 based on the data set provided. 

Qiu
20 - Arcturus
20 - Arcturus

I was misled by "in minutes" actually should be Count😁

Spoiler
Challenge_328.PNG