MAX_Bytes_20080402

Monday, 07 April 2008

TIP OF THE MONTH

Print Version

Produce a report to show the ranking of non-stop destinations available from LHR Terminal 5.

With the opening of T5 at Heathrow last week, we will guide you through how to make a report with a topical feel – ranking the non-stop destinations out of Terminal 5 at Heathrow Airport for the week commencing 7th April 2008.

Start by clicking on the ‘Run a New Query’ link in MAX Online’s homepage then set up your query using the yellow Query Filters in the Edit Query window;

Departure Airport Code(s)	DEPARTURE FROM folder
Passenger (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 variables as your Results Objects or .

Departure Airport Code	DEPARTURE FROM
Departure Terminal Code	DEPARTURE FROM
Arrival Airport Code	ARRIVAL folder
Arrival Airport Name	ARRIVAL folder
Frequency	FREQUENCY & CAPACITY folder

Your screen should look like the image below (click on the chart to view a larger image)

Click on Run Query, select LHR as Departure Airport Code. Select 2008-04-07 as the Week Commencing Date.

Click OK to run the report.

Max Online displays the table with the destinations of all LHR terminals.

Follow the steps below to focus on the results for terminal 5 only;

Click into the data contained within the Departure Terminal Code

Click the filter button in the Report Toolbar

Back

Select 5 from the list then click OK.

MAX Online displays only terminal 5 departures as illustrated in the screenshot below.

Back

Create a ranking by weekly frequency by clicking into the values contained within the Frequency column, then selecting Descend from the Apply/Remove sort from the Report Toolbar.

The report shows that Paris Charles de Gaulle is the most frequency used arrival airport during the week commencing 7th April 2008 with 73 flights.

Calculate the total number of weekly flights out of T5 by once again clicking into the data contained within the Frequency column and use the Sum function from the Insert Sum button in the Report Toolbar.

Back

A row and column will be inserted into the report displaying the total number of flights departing from London Heathrow Terminal 5, in this case 1,337.

Finally, change the format of the report to your preference by using the options in the properties tab pictured below.

Back

Below is an example of how you can use the properties options to add colour to your report.

Back