Monday 4th August 2008
TIP OF THE MONTH:
 

Produce a report and chart that display monthly capacity share by region.

In this week’s tip we will walk you through how to set up a table and pie chart to display the seat distribution by region for flights scheduled to occur in September 2008.

Start by clicking on the ‘Run a New Query’ link in MAX Online’s homepage then set up your query using the yellow Query Filters in the Edit Query window;

Passenger  (excluding surface)    SERVICE folder

Operating Flights Only

 CODE SHARE folder
Year & Month Number PERIOD folder
Non-Stop Flights only  ROUTING folder

Now select the following variables as your Results Objects or .

Departure Region Name

DEPARTURE FROM folder
Total Number of Seats FREQUENCY & CAPACITY folder


Your screen should look like the image below:

For this report simply click on Run Query, and select 200809.

Click OK to run the report.

The results of the report will be displayed in a table as per below.

Notice that MAX Online displays the results in alphabetical order.

Now, click into the data contained within the Total Number of Seats column.
Then, using the Apply remove sort button rank the Departure Regions by the Total Number of Seats into descending order.


The results will be displayed thus;

Using the table with the ranked data we will now create a pie chart to accompany our table to give us a graphical representation of the data.

Follow these steps below;

  1. Hover the mouse over the edge of the table. A grey border will appear to indicate that the whole table will be selected.  Press and hold the mouse button and the control key.  You will see that the cursor will now appear with a + sign indicating that you are going to copy the table.
  2. Release the buttons and a copy of the original table will appear.
  3. Hover over the second table and right click and select Turn To from the sub-menu.

A menu will appear as below;

From the menu select the Pie Chart then click OK. The pie chart will appear;

You can modify the layout of the pie chart by hovering over it right clicking and selecting Edit Format from the menu.

An Edit Format box will appear as below;

Using these options you can make the chart appear as below;