TIP OF THE MONTH:

Identify the number of international and domestic destinations available from an airport.

Example: We will create a report to show the number of destinations available from Jakarta Soekarno-Hatta airport in Indonesia.

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 and select ‘CGK’ as the Departure Airport Code(s) and ‘2007-03-12’ as the Week Commencing Date. 

As shown in the screenshot below, MAX Online will display all non-stop, domestic & international destinations available from Jakarta Soekarno-Hatta Airport. (Click on the chart to view a larger image)

Following the steps below we will modify the format of the report to identify the number of domestic & international destinations.

Step 1 – Click into the data contained within the International/Domestic
               column.

Step 2 – Click in the Insert/Remove Break icon located in the Report   
               Toolbar.

Step 3 – Now click into the Arrival Airport Name column.

Step 4 – Select Count from the ∑ drop down submenu in the Report
               Toolbar.

MAX Online will calculate the number of domestic and international destinations served out of Jakarta Soekarno-Hatta Airport.  The total for each group will appear at the bottom of its respective section.

Additionally, MAX Online will provide the overall number of destinations served at the foot of the report.  For the week commencing 2007-03-12 there is a total of 46 domestic and international points linked with CGK.

The look and feel of the report can then be customised using the options in the Properties tab.  An example of the final report is displayed in the image below. (Click on the screenshot to view larger image).

If you have any questions, please feel free to contact us anytime.