TIP OF THE WEEK:

How to produce a trend report and compare data over a multiple number of weeks.

You can quickly produce reports that compare data over a multiple number of weeks or months using the cross-tab feature.

Start setting up your query using the yellow query filters:

Now select the following fields as Results Objects.

Click on Run Query and select your preferred departure airport, plus however many weeks you wish to include in your analysis.

The resulting table will display the Week Commencing Date as a column. Right click on the values in this column and select Remove column from the sub-menu.  The column disappears, but you will see its result object in the left hand pane.  Now press and hold the Week Commencing Date object and then drag the object above the table.  A blue rectangle will appear indicating that the cross-tab will be added to the report. Release the mouse button and the total number of frequencies will be displayed in a week-on-week format.

Alternatively, you can run a day-on day or month-on-month report by replacing the Week Commencing Date filter and object with either the Calendar Date or Year & Month Number filter and object respectively.

This week’s hint from the MAX team

Would you like to know the specific routing of a flight?

Create a query and run a report using the following filters and objects and then click Run Query.

Filters:  Departure Airport Code, Passenger Flights (Excluding surface), Operating Flights Only, Week Commencing Date and Non-Stop Flights Only.

Objects:  Departure Airport Code, Arrival Airport Code, Frequency and Total Number of Seats.

Once you have run the report, click on Edit Query.  This will return you to the screen where you built your original query. Expand the ROUTING folder and double click on the Routing Airport Codes object to include this variable in your report.  Now click on Run Query. 

The Routing Airport Codes result’s object will be displayed in the left hand pane ready for you to introduce into your report.  All that remains for you to do is click and hold the object and then drag & drop it into the desired section of your report!