Example: Calculate the frequency share by departure airport and US state for all transatlantic flights into London Heathrow during October 2007.
On the homepage of MAX Online, click ‘Run a New Query’.
Start setting up your report by selecting the following yellow filters;
| Departure IATA Country Code(s) | DEPARTURE FROM folder |
| Arrival Airport Code(s) | ARRIVAL TO folder |
| All Flights (excluding surface) | SERVICE folder |
| Operating Flights Only | CODE SHARE folder |
| Year & Month Number(s) | PERIOD folder |
| Non-Stop Flights only | ROUTING folder |
Now select the following fields as Results Objects.
| Departure Airport Name | DEPARTURE FROM folder |
| Departure State Name | DEPARTURE FROM folder |
| Frequency | FREQUENCY & CAPACITY folder |
Your screen should look like the image below:
Click on “Run Query”. As the Departure IATA Country Code(s) select ‘US’. Choose ‘LHR’ as the Arrival Airport Code(s). For the Year & Month Number opt for ‘200710’.
Then, click on ‘OK’ to run the report.
The report shows the number of flights by departure airport and US state in alphabetical order.
Your screen should look like the image below
To rank the data, click into the ‘Frequency’ column and select ‘Descending’ from the Apply/Remove sort sub-menu.
The table shows that the airport with the highest number of non-stop flights to LHR is ‘New York JFK’ International Airport, with 577 transatlantic operations throughout October 2007.
To calculate the total number of flights offered by all US airports, click into the data contained within the ‘Frequency’ column and select ‘Sum’ from the ‘Insert Sum’ sub menu. A new row will be inserted at the foot of the table to display the value.
Then, from the same menu calculate the frequency share by airport by selecting the ‘Percentage’ option. This will create an extra column to the right of the Frequency column.
To change the display of your report to include different colours and font types use the options in the ‘Properties’ tab. Below is an example of how your final report could look like;
