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:
Departure Airport Code(s) |
DEPARTURE FROM folder |
| Operating Flights Only | CODE SHARE folder |
| All Flights (excluding surface) | SERVICE folder |
| Week Commencing Date(s) | PERIOD folder |
| Non-Stop Flights only | ROUTING folder |
Now select the following fields as Results Objects.
International/Domestic |
SERVICE folder |
| Arrival Airport Name | ARRIVAL TO folder |
Your screen should look like the image below:
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.
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.
If you have any questions, please feel free to contact us anytime.