TIP OF THE MONTH

Calculate a low cost carrier’s monthly capacity deployment on a country to country basis.

Example: For this month’s tip we will build a report that provides a country to country breakdown of easyJet’s available capacity during August 2007.

On the homepage of MAX Online, click ‘Run a New Query’.
Start setting up your report by selecting the following yellow filters;

Now select the following fields as Results Objects.

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


Click on “Run Query”.  Enter ‘U2’ when prompted as the ‘Carrier Airline Code’ (Note: If you wish to include operations from easyJet Switzerland SA, please add to your selection ‘DS’).  Double click on ‘200708’ for the ‘Year & Month Number’ and then click ‘OK’.

MAX Online displays August 2007’s seats offering for easyJet, country to country. 

(click on the screenshot below to view the enlarged image)

By clicking into the ‘Departure Country Name’ column and using the ‘Insert/Remove Break’ function situated in the Report Toolbar, we can identify the markets available out of each country and the total number of seats offered.

Below is how the screen will be displayed once you have grouped the data.

To calculate the total number of seats offered out of each country click into the data contained within the ‘Total Number of Seats’ column and then select ‘Sum’ from the ‘Insert Sum’ sub menu:

An extra row displaying the ‘total number of seats’ out of each country will be inserted at the foot of each table.

The countries can be ranked according to the total number of seats offered by clicking into the Total Number of Seats column and selecting ‘Descending’ from the ‘Apply/Remove’ Sort button that can be found in the Report Toolbar.

In order to display the origin country in each line (full name) click into the data contained within the ‘Departure Country Name’ column and then click into the ‘Properties tab’ in the left hand side window, followed by the ‘Break Properties’ tab in the furthermost left colum of the window. Then uncheck the ‘Remove Duplicates’ box.

The screen should be displayed as below;

Once again by using the options in the ‘Properties’ tab you can change the format of the report so it is displayed as our example below;