TIP OF THE WEEK:

Identify the number of flights departing from Bulgaria and Romania in February 2007 by arrival airport and region.

On the homepage of MAX Online, click ‘Run a New Query’.
Start building 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 ‘BULGARIA’ and ‘ROMANIA’ as your ‘Departure Country Name(s)’ and ‘200702’ as your preferred ‘Year & Month Number(s)’.

Now click ‘OK’ to run the report. 

(click on the screenshot to view the enlarged image)

The results show the distribution of all flights departing from Bulgaria and Romania in February 2007 by arrival region. 

Following the steps below you can drill down and split these flights by arrival airport.

Step 1 – Sort the ‘Frequency’ data in descending order utilising the tabs below (you need to click first within the column containing the ‘Frequency’ data).

Step 2 – Click on ‘Edit Query’.

Step 3 – From the ‘ARRIVAL TO’ folder, drag and drop the ‘Arrival Airport Code’ into your report panel.

Step 4 – Click on ‘Run Query’ and then ‘OK’.

The additional variable (Arrival Airport Code) will now be included in your Data tab on the left hand side.

Step 5 – Drag and drop the Arrival Airport Code into the table as shown in the image below.

By following the steps below you can group the flights from Romania and Bulgaria.

Step 6 – Click into the data contained within the ‘Departure Country Name’ column.

Step 7 – Now select the Insert/Remove Break icon that is displayed in the top toolbar.

The results will now be grouped by ‘Departure Country Name’ as shown below (click on the screenshot to view the enlarged image). 

Step 8 – Customise your report using the options in the ‘Properties’ tab to give it a similar look and feel to the example provided below (click on the chart to view a larger image).

If you have any queries relating to anything on this newsletter or if you need any assistance with any of the functions within the MAX tool, please do not hesitate to contact us.