Reports and Dashboards Creation and Use Cases
The Galooli Pro application allows the user to access valuable data quickly and easily.
In the Pro application, these data are displayed using the value reports.
Report preparation involves a number of steps that will ultimately provide you with the most accurate results for the needs of the organization as a whole and the unit activity in particular.
This article will provide a list of the recommended steps along with an example use case.
Basic Steps
Map the data you wish to be displayed in the report . As part of the mapping procedure, you need to have a general idea of the type of data you wish to obtain:
Detailed Data - Provides the ability to view detailed raw data on a single unit for a single transmission.
Asset Data - Provides information about the current status of one or more units.
Events Data - Provides a summary of all events that occurred for the selected units at the selected time
Summary Data - Provides a summary of data and is used to analyze and view aggregated information/analytics for a large number of units
Find out which existing views and dashboards in the Galooli Panorama application can be adapted to create your report. The fields that are used as the basis for the view/dashboard can be viewed in the Panorama application; this allows you to copy them and use them for your reports.
Depending on the type of data, it is important to select the appropriate fields:
Detailed and Asset data - Use the Live ModeOpen the Pro Application >> Select the desired organization/cluster/group/unit from the organization tree.
Please note that if you choose to run the report on more than one unit, it will not be possible to run it
as a detailed report. Detailed report may only be generated on a single unit.Select the desired system report type. Selecting the right report type will ensure that the fields you select in the following steps will be suitable for your report.
Detailed Report
Asset Report
Events Report
Summary Reports
On the “Selected Fields” window, click on “+Add Field” >> “System Parameter”. The window that appears will contain groups of fields. In order to find the fields themselves, you may use the search bar or open the relevant groups based on the purpose of the report and mark the fields that you need.
It is important that each field be relevant to the type of report that you have selected in the previous section.
Detailed Report - Use the “recorded” fields
Summery Report - Use the relevant summery fields - Summary ReportsOnce you have selected all the relevant fields, it would be a good idea to give them meaningful names and filter the data in order to obtain an accurate end report. Additionally, you can move the fields one above the other so that the table titles in the final report will reflect your personal preferences.
Report List and List of Available Fields
Reports Common Concepts - Used for advanced data filteringGalooli provides you with the option of creating new fields based on the calculation of other fields when you need a field that is not included in Galooli's fields bank.
Reports Common ConceptsSelect the appropriate time period of the report. Reports of different types have different time frames.
Report Type | Max days for report execution - Limited | Max days for report execution - Extended |
Asset | Time Selection does not appear in this case | Time Selection does not appear in this case |
Summary | 92 | 366 |
Detailed | 14 | 92 |
Event | 31 | 92 |
Trips | 14 | 92 |
When creating a summary report, it is important to select the "Data Aggregation” according to your
requirements.
You should save the report and give it a meaningful name. You will find the report in the "My Reports” section.
10. Run the report and check that you get the relevant data. The platform through which you view the final report may be used for an in-depth analysis of the data as follows:
It is possible to refine the search results by filtering and sorting the columns/fields names
You can make a mathematical calculations for each column
You can export the data from the Galooli platform to PDF, CSV, Excel.
Detailed reports can display the end result on a graph and on a map
Once you have ensured that your report contains the best fields that represent your needs, consider making the report a schedule report, so you and your employers will receive the results automatically at the frequency you specify. Additionally, you can share the report you prepared with your colleagues.
My Schedule Dashboards & Reports
My Shared Reports
The last step in creating the most effective and useful report is to create a dashboard based on this report. Galooli dashboard designer allows you to create customized dashboards and visually display all the data that can be accessed through Galooli's reporting system.
https://galooli.atlassian.net/l/cp/bgpGWXG8