Reportings

The Reportings view allows you to download files with the information we request within the available options.

Download Reportings

From the list of options, select the data you want to download.
A menu will appear on the right, and you will need to fill in the fields.

In "Format Options," you can choose how you want the file to be downloaded: Excel or CSV (with information separated by commas or semicolons). If you click on [Save Options], the manage will remember your preferences for future downloads.

There are 2 options to generate the reporting:

The first option, the button Create Reporting and Download , is designed for small files. The reporting will start generating immediately and, afterwards, the message "file generation in progress" (visible at the top) will change to a download notification. You will then be able to view or download the file from that notification.

The second option, the button Add Reporting to Queue . This option is useful if you want to generate several reportings at once and download them later in bulk, or if the reporting is expected to be very large. If the system detects that the file will be too large, this will be the only active option.

Reporting Processing Queue and Reporting Downloads

At the top right, you will find the button Reports.

This button will open a modal containing the Reporting Processing Queue and the list of Ready-to-Download Reportings.

The Processing Queue is global, meaning there may be reportings of other types, including those from other system users. Viewing the queue is useful to get an approximate idea of the waiting time before you can download your requested reporting.

The list of Ready-to-Download Reportings shows the reportings you can download by clicking the button.

Detailed Reports of Reportings

Below are the fields included in each report

Bus usage and distance traveled by agency, broken down by line

Fields in this report:

Bus: Indicates the name of the bus.
Date: Indicates the date.
Line: Indicates the line the bus has traveled.
Route: Indicates the route the bus has traveled.
Active Time (min): Indicates the time in minutes the vehicle has been on a scheduled trip.
Distance (m): Indicates the distance traveled in meters.

Bus usage and distance traveled WITHOUT line breakdown

Fields in this report:

Bus: Indicates the name of the bus.
Date: Indicates the date.
Active Time with trip (min): Indicates the time in minutes the vehicle has been on a scheduled trip.
Distance with trip (m): Indicates the distance traveled in meters during a scheduled trip.
Active Time without trip (min): Indicates the time in minutes the vehicle has been traveling without a scheduled trip or is in a lost state.
Distance without trip (m): Indicates the distance traveled in meters outside of a scheduled trip.
Total Active Time (min): The sum of active time with trip and active time without trip.
Total Distance (m): The sum of distance with trip and distance without trip.

Daily Punctuality by Bus

Fields in this report:

Bus: Indicates the name of the bus.
Line: Indicates the line the bus has traveled.
Date: Indicates the date.
Total Actual Records: Real-time data for stop passes.
Total Theoretical Records: Planned stop passes.
Valid: Actual records that fall within the very late and very early parameters.
Punctual: Number of valid records classified as punctual. The punctuality parameters can be consulted and modified in Edit Punctuality Values within the relevant report. The parameters are global and affect all reports that include these values.
Very Punctual: Number of valid records classified as very punctual.
Advanced: Number of valid records classified as advanced.
Very Advanced: Number of valid records classified as very advanced.
Delayed: Number of valid records classified as delayed.
Very Delayed: Number of valid records classified as very delayed.
% Punctuality: The percentage of valid records that are punctual and very punctual.

Detailed punctuality of first and last stops by line

Fields in this report:

Line: Indicates the line the bus has traveled.
Date: Indicates the date.
Total Actual Records: Real-time data for stop passes.
Total Theoretical Records: Planned stop passes.
Valid: Actual records that fall within the very late and very early parameters.
Punctual: Number of valid records classified as punctual.
Very Punctual: Number of valid records classified as very punctual.
Advanced: Number of valid records classified as advanced.
Very Advanced: Number of valid records classified as very advanced.
Delayed: Number of valid records classified as delayed.
Very Delayed: Number of valid records classified as very delayed.
%Punctuality: The percentage of valid records that are punctual and very punctual.

Punctuality of First and Last Stops by Line

Fields in this report:

Date: Indicates the date.
Bus: Indicates the name of the vehicle.
Driver: Indicates the name of the driver.
Route: Indicates the route the bus has traveled.
Trip: Indicates the trip code.
Theoretical First Stop Departure Time: The time the vehicle is theoretically scheduled to leave the first stop.
Actual First Stop Departure Time: The actual time the vehicle leaves the first stop.
Theoretical Last Stop Arrival Time: The time the vehicle is theoretically scheduled to arrive at the last stop.
Actual Last Stop Arrival Time: The actual time the vehicle arrives at the last stop.

Monthly Punctuality by Line

Fields in this report:

Bus: Indicates the name of the vehicle.
Line: Indicates the line the bus has traveled.
Date: Indicates the date.
Total Actual Records: Real-time data for stop passes.
Total Theoretical Records: Planned stop passes.
Valid: Actual records that fall within the very late and very early parameters.
Punctual: Number of valid records classified as punctual.
Very Punctual: Number of valid records classified as very punctual.
Advanced: Number of valid records classified as advanced.
Very Advanced: Number of valid records classified as very advanced.
Delayed: Number of valid records classified as delayed.
Very Delayed: Number of valid records classified as very delayed.
%Punctuality: The percentage of valid records that are punctual and very punctual.

Detailed data by line and day

Fields in this report:

Bus: Indicates the name of the vehicle.
Driver: Indicates the name of the driver.
Line: Indicates the line that was traveled.
Route: Indicates the route that was traveled.
Date: Indicates the date.
Expedition: Indicates the code that identifies the expedition.
Event type: Events can be 3: head departure, stop pass, control stop/reference stop pass.
Event detail type: Refers to the stop where the event occurs.
Position: Correlative numbers to identify the event.
Head arrival: Time when the vehicle was at the head.
Theoretical time: Time when the vehicle is theoretically supposed to arrive at the event stop.
Reference time: AMB concept that usually coincides with the theoretical departure time.
Arrival time: Actual arrival time at the event stop.
Departure time: Actual departure time from the event stop.
Theoretical difference: Difference between the theoretical time and the reference time.
Arrival difference: Seconds obtained by subtracting the theoretical time from the arrival time.
Departure difference: Seconds obtained by subtracting the reference time from the departure time.
Valid: Records that could be quantified.
Correct: Real records within the very delayed and very advanced parameters.
Punctual: Number of valid records classified as punctual.
Very punctual: Number of valid records classified as very punctual.
Advanced: Number of valid records classified as advanced.
Very advanced: Number of valid records classified as very advanced.
Delayed: Number of valid records classified as delayed.
Very delayed: Number of valid records classified as very delayed.
% Punctuality: The percentage of valid records that are punctual and very punctual.

Occupancy

Fields in this report:

Date: Indicates the date.
Bus: Indicates the name of the vehicle.
Line: Indicates the line that was traveled.
Route: Indicates the route that was traveled.
Expedition: Indicates the code that identifies the expedition.
Start time: Time when the expedition theoretically starts.
Position: Correlative numbers to identify the position where the counting occurs.
Stop Name: Indicates the name of the stop where the counting takes place.
Stop Code: Indicates the code of the stop where the counting takes place.
Boarded: Indicates the number of passengers who entered the vehicle.
Alighted: Indicates the number of passengers who exited the vehicle.
Total: The sum of passengers who boarded and alighted.
Theoretical time: Time when the vehicle is theoretically expected to pass the stop.
Actual time: Actual time when the passenger count is performed.

Expeditions without data calculation

Fields in this report:

Line: Indicates the line that was traveled.
Start date: Indicates the first date for which data is requested.
End date: Indicates the last date for which data is requested.
Theoretical expeditions: Indicates how many expeditions should have records.
Expeditions without records: Indicates how many expeditions have no records.
Expeditions with erroneous records: Indicates how many expeditions have records but are erroneous (outside punctuality parameters).
Expeditions with valid records: Expeditions with at least one record within punctuality parameters.

Travel time calculation

Fields in this report:

Line: Indicates the line that was traveled.
Date: Indicates the date.
Bus: Indicates the name of the vehicle.
Driver: Indicates the name of the driver.
Expedition: Indicates the code that identifies the expedition.
Travel time (s): Seconds the vehicle was traveling a trip.

Air quality

Fields in this report:

Date: Indicates the date.
Time: Indicates the time.
Latitude: Indicates the latitude where the vehicle was located.
Longitude: Indicates the longitude where the vehicle was located.
Pressure: Indicates the atmospheric pressure in mbar.
Temperature: Indicates the temperature in degrees Celsius.
Humidity: Indicates the humidity in percentage.
Dew point: Indicates the dew point in degrees Celsius.
AQI: Air Quality Index.
Bus: Indicates the bus providing the information.

Driving quality

Fields in this report:

Date: Indicates the date.
Time: Indicates the time.
Driver: Indicates the driver of the vehicle.
Vehicle: Indicates the vehicle.
Line: Indicates the line that was traveled.
Route: Indicates the route that was traveled.
Trip: Indicates the trip that was traveled.
Stop: Indicates the stop.
Latitude: Indicates the latitude where the vehicle was located.
Longitude: Indicates the longitude where the vehicle was located.
X: Indicates the X newtons.
Y: Indicates the Y newtons.
Z: Indicates the Z newtons.

Incidents

Fields in this report:

Creation date: Indicates the date the incident was created.
Creation time: Indicates the time the incident was created.
Vehicle: Indicates the vehicle.
Type: The incident type can be manual, created by an agent from the management system, or automatic, created by the bus if certain parameters are not met.
Title: The title assigned to the incident.
Latitude: Indicates the latitude where the vehicle was located. (only for automatic incidents)
Longitude: Indicates the longitude where the vehicle was located. (only for automatic incidents)
Freshdesk ID: If the incident was sent via Freshdesk, it is assigned a unique ID.
Closure date: The closure date of the incident.
Closure time: The closure time of the incident.
Duration (days): How many days the incident has been open.
Comment: Comment assigned to the incident if any.

FMS

Fields in this report:

Date: Indicates the date.
Time: Indicates the time.
Driver: Indicates the driver of the vehicle.
Vehicle: Indicates the vehicle.
Line: Indicates the line that was traveled.
Route: Indicates the route that was traveled.
Trip: Indicates the trip that was traveled.
Stop: Indicates the stop.
Latitude: Indicates the latitude where the vehicle was located.
Longitude: Indicates the longitude where the vehicle was located.

Time between stops

Fields in this report:

Date: Indicates the date.
Line: Indicates the line that was traveled.
Route: Indicates the route that was traveled.
Trip: Indicates the trip that was traveled.
Origin stop: Indicates the origin stop.
Origin code: Code identifying the origin stop.
Theoretical departure: Date and time of the theoretical departure.
Actual departure: Date and time of the actual departure.
Destination stop: Indicates the destination stop.
Destination code: Code identifying the destination stop.
Theoretical arrival: Date and time of the theoretical arrival.
Actual arrival: Date and time of the actual arrival.
Seconds between stops: Time elapsed between the origin and destination stops.

Emergency pedal

Fields in this report:

Date: Indicates the date.
Time: Indicates the time.
Bus: Indicates the vehicle code.
Latitude: Indicates the latitude where the vehicle was when the pedal was activated.
Longitude: Indicates the longitude where the vehicle was when the pedal was activated.
Driver: Indicates the driver's name.
Line: Indicates the line that was traveled.
Route: Indicates the route that was traveled.
Expedition: Indicates the expedition being traveled.