TIP OF THE WEEK:

How to identify the number of first class seats offered by all airlines worldwide.

Start setting up your query using the yellow query 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 and select 200701’ as the Year & Month Number(s).

Now click OK to run the report. 

The report displays the total number of first class seats offered by an airline for January 2007.

By creating an ‘Alerter’ you can instantly identify those airlines which offer first class seats.

Click on the data that is contained within the Number of First Class Seats column.  Now click on the red triangle ‘Alerter’ icon that is positioned in the Report toolbar.  The ‘Alerter’ icon is displayed in the following format.

In the Alerter pop up box, click New.  The Alerter Editor will be displayed.  Enter an Alerter Name’ e.g. ‘Number of First Class Seats’. 

From the Operator drop down menu select the Greater than option and then in the Operand section type the value ‘0’.  Now click Format.  

The Alerter Display pop up box appears.  From the Text section select ‘Font’ ‘Bold’, ‘Size’ ‘10’ and ‘Background Color’ ‘Yellow’. 
                                                                                               
Press OK in the Alerter Display, OK in the Alerter Editor and OK in the Alerter.  In the results table OAG MAX Online shows all airlines whose weekly number first class seats is greater than 0.

To remove the Alerter click on the data within the Number of First Class Seats column.  Click on the ‘Alerter’ icon.  Select Remove and choose OK.

NB.  The ‘Alerter’ can be also used to select different types of criteria such as ‘Equal to’, ‘Different from’ as well as ‘Between’.  The available options can be found in the ‘Operator’ drop down menu of the ‘Alerter’ function.

Scroll down the table to view the highlighted cells (click on the screenshot to view the enlarged image).

By following the steps below we can examine the results further by revealing the total number of first class seats and ranking the data in descending order to identify those carriers offering the greatest number of first class seats in January 2007:

Step 1 – Click within the data contained in the ‘Number of First Class Seats’ column.  Click on the ‘Insert Sum’ option on the Report toolbar and then select ‘Sum’ from the sub-menu as shown in the image below.

Step 2 – Rank the results using the tabs below.

The following screenshot shows the results of the query having incorporated Steps 1 and 2 from the previous page.
                                             
(click on screenshot below to view larger image – please note that the total number of seats value will be displayed at the bottom of the report)

The resulting table shows that American Airlines, United Airlines and Delta Air Lines are the carriers who offer the greatest number of first class seats for the specified period.

You can give your report a similar look and feel to the example below by using the options in the ‘Properties’ tab: