User Tools

Site Tools


leon:report-wizard

REPORT WIZARD

Report Wizard - the main view on saved reports

Report Wizard has been created to replace in the future Custom Flights List report. The main aim was to allow quick & easy creating & storing various type of reports in one page (crew flight times, aircraft block hours, fuel usage, PAX data, etc….).

Each created and saved report can be edited and re-arranged in many ways. Leon users can decide what columns should get displayed in the report and in what order, they can choose period of time for each report and name each report the way they want.

Report Wizard is available in a section Reports, at the top of the drop-down list. All saved reports can be found in general Report Wizard page.

reports drop down.png

Creating a report

Creating a report in a Report Wizard panel in Leon

Click add-report-icon.png icon at the bottom and you will be transferred to the new page. Here, on the left-hand side you can find a filter with available data items, which - when marked - create columns in the report. Used items turn from not used item.png into used item.png You can use a field 'Search' to quickly find a desired item. You can also add items by dragging & dropping the item from the filter staright into the 'Columns' bar.

When creating a new report Leon shows 7 default columns:

  • DATE ADEP Plan UTC
  • Flight number
  • Registration
  • STD UTC
  • ADEP ICAO Plan
  • STA UTC
  • ADES ICAO Plan

Displayed columns can be manually changed by clicking columns changer.png icon. When columns-names show, simply click & place a particular column to where you wish it to be.

Once the report is done you can save it giving it a name (use 'Save as' button) and it will be available in the main Report Wizard page. Saved report name can always be changed in the top-part of the creating when you click pen-icon in the report name changer.png link.

You can export a created report to PDF (by clicking report export.png icon), or to Excel (by clicking export excel.png icon) - in top-right corner of the page.


Personal reports

Visibility of the saved reports in Wizard

Each Leon user who has the access to the Wizard Report is now able to create and save a report to which no other user will have access.

After creating the report, right next to the field where the report can be named/renamed there is a checkbox visible checkbox.png - if it's marked, that report will be visible ONLY to the user who has created it - no other user will see it, unless the checkbox is unmarked.

If the checkbox is unmarked all users will see the report and will be able to view it BUT will not be able to make changes to it (SAVE button will be inactive).

On the main Wizard Report page, in a column Visibility each user can check which reports have been enabled to all users (indication 'Company') and which ones are blocked (indication 'Only me').


Positioning reports

Example of positionings report in Wizard

When adding a new report, Leon will show a pop-up window where you will need to select a Scope: either 'Flight', 'Positioning' or 'Flights Aggregated Statistics'.

scope.png

By selecting a scope 'Posiotioning' you will get date related to positionings ONLY, so both: columns & filters options will be narrowed down.


Flights Aggragated Statistics reports

Flights Aggragated Statistics report

Flights Aggregated Statistics report allows creating the reports with the data combined from a number of measurements.

In order to create such a report, choose the 'Flights Aggregated Statistics' from the dropdown selection in the pop-up window while adding the new report.

FAS.png

Once you open the report, there are different available data comparing to 'Flight' or 'Positioning' type of report.

Looking at the 'Available Fields' section on the left-hand side, there are 5 measurements available:

  • Flights count
  • Block time [JL] [AVG]
  • Block time [JL] [SUM]
  • Block time [Plan] [AVG]
  • Block time [Plan] [SUM]
Bar chart view

Once you chose the 'Available Fields', the data in the report can be presented in 2 different views:

  • Table view - standard table view upon clicking on FAS column icon.png icon.
  • Bar chart view - view represented in the screenshot on the right-hand side, available upon clicking on the FAS bar chart icon.png icon. the data shows in a tooltip upon hovering the mouse over the specific bar.

The data displayed can be grouped by:

  • PAX - calculating data for PAX.
  • Aircraft type - calculating data for a specific type of the aircraft.
  • Aircraft - calculating data for a specific aircraft registration.

The filtering options are also limited to selecting aircraft, aircraft type and the flights with or without Journey Log.


Long-period reports

It is possible to generate a long-period reports in Wizard, for more than 90 days.

When generating a new report or editing already saved report in Wizard for a period of more than 90 days, Leon will show Time range too long warning, however, you will still be able to generate the report.

Click a blue button generate in background.png and after a few seconds Leon will show an information: Report successfully ordered. Go back to the main Wizard page and on the right-hand side of the screen you will see the progress-icon progress icon.png

Once the report publication is done Leon shows 'Download' icon allowing you to view the report in Excel file.

report published.png

Filters

Calendar

In the top-right corner you can find date-selector where you can use either a button today button.png and navigate with arrows, or click date selector.png to open a calendar where you can mark period of time. You can also use one of the available, pre-defined options on top of the calendar: Today, Last 7 days, Previous month or This month.

Data filter

By clicking the filter icon.png icon Report Wizard allows to narrow down the displayed data by various details, such as: aircraft type & registration, ADEP & ADES, Flight number, Trip type, Cancelled legs or legs with Journey Log added.

Click Add and Leon will show a pop-up window (as on the screenshot on the right) where you can choose available data: click a particular one and either mark appropriate details, as per example below, where only 3 tails are selected:

Data filter in Report Wizard
Filter applied to narrow down displayed data

filter example.png

or, you can simply enter a value (i.e. Flight number/numbers) and add it to the filter the report:

filter example 2.png

All chosen values added to the filter show above the report data and can always be removed by clicking on X when hovered the mouse over.

Sharing reports

Sharing tool in Report Wizard

In the top-right corner of the report screen, under the sharing icon: share icon.jpg a URL link can be generated. By Clicking share link.jpg and entering the short name of the report, Leon will generate a link, which when inserted into the web address belt of the browser, will download the csv file with the content of the report.

The functionality is mainly aimed at Customers who wish to export data from Leon to various BI systems including Google Data Studio and Qlik.

leon/report-wizard.txt · Last modified: 2019/05/27 09:11 by bartek