Identify the volume of flights from the United States of America to the EU27 Member States.
For this month’s tip we will create a report with a topical feel, given the recent events concerning the Open Skies Agreement between the United States of America and the European Union.
Example: Design a report that displays a ranking by frequency for flights departing from the US to countries within the European Union.
On the homepage of MAX Online, click ‘Run a New Query’.
Start setting up your report by selecting the following yellow filters;
Departure Country Code(s) |
DEPARTURE FROM folder |
| Arrival Country Name(s) | ARRIVAL TO folder |
| Operating Flights Only | CODE SHARE folder |
| Passenger (excluding surface) | SERVICE folder |
| Year & Month Number(s) | PERIOD folder |
| Non-Stop Flights only | ROUTING folder |
| Exclude All Traffic Restrictions | RESTRICTIONS folder |
Now select the following fields as Results Objects.
Departure Country Name |
DEPARTURE FROM folder |
| Arrival Country Name | ARRIVAL TO folder |
| Frequency | FREQUENCY & CAPACITY folder |
Your screen should look like the image below
Click on ‘Run Query’ and select ‘UNITED STATES OF AMERICA’ as the Departure Country Name. For the Arrival Country Name we will enter each of the 27 EU countries*. We will then select ‘200705’ as the Year & Month Number.
*The 27 countries of the European Union are listed at the end of the Tip.
Now click ‘OK’ to run the report.
The report will display the monthly frequency by arrival country sorted in alphabetical order.
By clicking into the data contained in the Frequency column and selecting the ‘Descending’ option from the ‘Apply/Remove Sort’ sub-menu we can create a ranking report by monthly frequency for the flights departing out of the United States of America arriving in the 27 countries of the European Union.
To determine the total number of flights between the United States and EU27, click once again in the Frequency column and then opt for Sum from the ‘Insert Sum’ sub-menu. The total value will be displayed in the bottom row of the report.
By customising the format of the report you can create a look and feel similar to that of the screenshot below.
The 27 Countries of the European Union:
Austria
Belgium
Bulgaria
Cyprus
Czech Republic
Denmark
Estonia
Finland
France
Germany
Greece
Hungary
Ireland
Italy
Latvia
Lithuania
Luxembourg
Malta
Netherlands
Poland
Portugal
Romania
Slovakia
Slovenia
Spain
Sweden
United Kingdom
If you have any questions, please feel free to contact us anytime.