Disclaimer: features differ based on Subscription Plan


The Statistics table consists of selected columns and their values.

_scroll_external/attachments/statistics_en-cb126b655b5296e13919c66ea0d8f05444cc35059727531948a371084626a621.png

The table gives information on the report as a whole, for example, on the beginning and end of the report interval, the number of messages, the name of the unit, the time zone, the time of report execution, and other statistics, depending on the selected report template type.

To add the statistics table to a report template, click on the Statistics button on the Report Contents tab of its properties.

In the dialog window of the Statistics table properties, select the columns that should be included in the table. To find the required ones, use the dynamic search located in the upper right corner. Search is carried out both by the name of the column (to the left) and by the type to which it belongs (to the right).

To change the name of the column, click on it with the left mouse button and make the changes. To cancel changes, click on the Default icon (). The icon is inactive if the name has not been changed.

You can also change the sequence of columns. To do this, drag the icon located to the left of the required column name.

The statistics table is added to the list of contents of the report template. It always goes first and cannot be moved.

Below are the available columns that can be added to the statistics table for the reports of the Units type.

Statistics

Column

Description

Report

The name of the report template.

Unit

The name of the unit.

Report execution time

The time of report generation when a user executed the report online or it was generated automatically as a job or notification.

Interval beginning

The beginning of the reporting interval.

Interval end

The end of the reporting interval.

Time zone

The time zone set in the user settings.

Messages

The messages analysed within the reporting period.

Mileage in all messages

The mileage in all messages according to the selected mileage counter (without filtration by the trip detector).

Consumed

The amount of consumed fuel detected by any sort of fuel sensor. If several such sensors are available, their values sum up.

Consumed by ImpFCS/AbsFCS/InsFCS/FLS/math/rates

The amount of consumed fuel detected by a fuel sensor (such as impulse/absolute/instant fuel consumption sensor, fuel level sensor) or calculated by math or rates.

Consumed by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in motion

The amount of fuel consumed during the movement of the unit calculated by the methods described above.


The movement is considered those intervals in which the speed value was greater or equal to the one from the Min moving speed field in the trip detector.


Consumed by ImpFCS/AbsFCS/InsFCS/FLS/math/rates without motion

The amount of fuel consumed during the time when the unit was without movement calculated by the methods described above.

Avg consumption

The average fuel consumption by any sort of fuel sensor. If several such sensors are available, their values sum up.

Avg consumption by ImpFCS/AbsFCS/InsFCS/FLS/math/rates

The average fuel consumption in trips detected by one of the methods mentioned above. It can be presented either as liters per 100 kilometers or miles per one gallon. The whole mileage of the reported interval is normally taken for these calculations. However, average consumption by FLS can take either all mileage or mileage by the trip detector. 

Initial fuel level

The fuel level at the beginning of the interval.

Final fuel level

The fuel level at the end of the interval.

Max fuel level

The maximum fuel level.

Min fuel level

The minimum fuel level. More information about the fuel in reports can be found here.

Engine hours

Column

Description

Engine hours

The duration of the engine hours. It can be calculated by the engine hours sensor or by the ignition sensor depending on the unit properties.

Initial engine hours

The value of the engine hours at the beginning of the interval.

Final engine hours

The value of engine hours at the end of the interval.

In movement

The time interval during which the unit was in motion.

Idling

The total time interval during which the unit did not move with the engine running (idling).

Mileage in engine hours

The distance travelled during the engine hours operation.

Initial mileage in engine hours

The value of the mileage sensor at the moment of the beginning of the reporting period.

Final mileage in engine hours

The value of the mileage sensor at the end of the reporting period.

Avg engine revs

The average rate of engine revolutions.

Max engine revs

The maximum rate of engine revolutions.

Avg temperature in e/h

The average temperature during the engine hours.

Engine efficiency duration

The duration of the attached implements operation (if there is an engine efficiency sensor).

Engine efficiency idling

The engine hours minus the engine efficiency time.

Utilization

The duration of the engine hours work divided by the engine hours rate, indicated on the Advanced tab of the device properties.

Useful utilization

The duration of the engine efficiency divided by the engine hours rate.

Productivity

The duration of the engine efficiency divided by the engine hours duration.

Consumed in e/h

The volume of the consumed fuel detected by any sort of fuel sensor. If several such sensors are available, their values sum up.

Consumed by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in e/h

The fuel volume used in engine hours. It can be detected by a fuel sensor (such as impulse/absolute/instant fuel consumption sensor, fuel level sensor) or calculated by math or rates. More information about the fuel in reports can be found here.

Avg consumption in e/h

The average fuel consumption by any sort of fuel sensor. If several such sensors are available, their values sum up.

Avg consumption by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in e/h

The average fuel consumption in the engine hours determined in accordance with a fuel sensor readings or calculated by math or rates.

Consumed by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in motion

The average fuel consumption in motion.

Avg consumption by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in motion

The amount of fuel consumed at idle determined in accordance with a fuel sensor readings or calculated by math or rates.

Consumed by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in idle run

The fuel volume used in the engine hours during idle running determined in accordance with a fuel sensor readings or calculated by math or rates.

Avg consumption by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in e/h in trips

The average fuel consumption during the work of engine hours in trips determined in accordance with a fuel sensor readings or calculated by math or rates.

Events

Column

Description

Events count

The number of registered events.

Fuel fillings

Column

Description

Total filled

The volume of fuel filled during the reporting interval.

Total registered

The registered fuel volume regardless of binding to sensors and calculation methods.

Difference

The difference between the registered and detected fillings.

Total fillings

The number of fuel fillings detected within the reporting period.

Fuel thefts

Column

Description

Total fuel stolen

The total volume of stolen fuel.

Total thefts

The number of thefts detected within the reporting period.

SMS messages

Column

Description

SMS messages

The number of SMS messages received from a unit.

Speedings

Column

Description

Initial mileage

The mileage sensor reading at the time of the start of the first speeding at the reporting interval. If there is no mileage sensor, the mileage is counted from 0.

Final mileage

The mileage sensor reading at the end of the speeding interval.

Parkings

Column

Description

Parking time

The total duration of parkings for the reporting period. Parking is determined by the trip detector. If it is disabled, the number of parkings is counted as zero.

Parkings count

The number of parkings for the reporting period.

Trips

Column

Description

Move time

The total duration of all trips.

Engine hours

The engine hours value.

Mileage in trips

The total distance travelled in all trips.

Mileage (adjusted)

The total mileage of the movement intervals determined by the trip detector, multiplied by mileage coefficient (the setting in the additional properties of the unit).

Urban mileage in trips

The distance travelled at a speed that is defined as the speed in the city.

Suburban mileage in trips

The distance travelled at a speed that is defined as the speed outside the city. The speed limit is configured in the additional settings of the unit.

Initial mileage

The mileage sensor value at the beginning of the reporting interval (it makes sense if there is an absolute odometer).

Final mileage

The mileage sensor value at the end of the reporting interval.

Average speed in trips

The average speed in trips (total mileage divided by the time of travel).

Maximum speed in trips

The maximum speed registered during the trips.

Trips count

The number of trips.

Consumed in trips

The volume of consumed fuel detected by any sort of fuel sensor. If several sensors are available, their values sum up.

Consumed by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in trips

The fuel consumed in trips. It can be detected by a fuel sensor (such as impulse/absolute/instant fuel consumption sensor, fuel level sensor) or calculated by math or rates. More information about fuel in reports can be found here.

Rates deviation by ImpFCS/AbsFCS/InsFCS/FLS in trips

The difference between the fuel consumption detected by a sensor and the fuel consumption rates.

Avg consumption in trips

The average fuel consumption by any sort of fuel sensor. If several such sensors are available, their values sum up.

Avg consumption by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in trips

The average fuel consumption in trips determined in accordance with a fuel sensor readings or calculated by math or rates.

Avg mileage per unit of fuel by ImpFCS/AbsFCS/InsFCS/FLS/math/rates in trips

The average fuel consumption presented as kilometers per liter or as miles per gallon.

Violations

Column

Description

Violations count

The number of violations registered within the reporting period.

Executed commands

Column

Description

Executed commands

The number of commands sent to a unit.

Unit latest data

All the columns in this section do not depend on the reporting interval. The latest information is taken at the moment of the report execution.

Column

Description

Mileage counter

The mileage counter value.

Engine hours counter

The engine hours counter value.

GPRS traffic counter

The consumed traffic.

Unit last location

The latest unit location detected (address or coordinates).

Last message time

The time when the latest message from the unit was received.

Visited streets

Column

Description

Streets count

The number of visits of streets.

Maintenance

Column

Description

Total maintenance duration

The duration of all registered services.

Total maintenance cost

The total cost of all maintenance works.

Services count

The number of services performed.

Utilisation cost

Column

Description

Total utilisation cost

The total cost of all registered service works and fuel fillings.

Count of services and fillings

The total number of all registered service works and fuel fillings.

Counter sensors

Column

Description

Total counter

The sum of values of all sensors of the counter type.

Images

Column

Description

Images

The number of images received from the unit. And if there are any, the resulting report contains a section with all the received images for the reporting period. The supported format is JPEG.

Eco driving

Column

Description

Penalties

The overall penalty for various Eco driving criteria for the reporting period.

Rank

The received penalty points converted into a grade using a 6-point scoring system.

Video

Column

Description

Video

The list of video files received from a unit.

Orders

Column

Description

Total orders

The total amount of orders within the indicated time period.

Orders visited

The orders in which the arrival of a courier to an address is detected or any status is set.

Orders visited in time

The orders in which the arrival of a courier to an address is detected on time (in advance) or any status is set.

Orders visited late

The orders in which the arrival of a courier to an address is detected late or any status is set late.

Non-visited orders

The orders in which the arrival of a courier to an address is not detected.

Orders fulfilled

The orders in which the arrival of a courier to an address is detected, the Confirm status is set.

Orders fulfilled in time

The orders which are fulfilled on time (in advance), the Confirm status is set.

Orders fulfilled late

The orders which are fulfilled late, the Confirm status is set.

Orders visited without status

The orders in which the arrival of a courier to an address is detected, status is not set.

Orders rejected

The orders for which the Reject status is set.

Order's avg time (estimated)

The ratio of the time calculated by the system for the delivery of all orders to the total number of orders.

Order's avg time (actual)

The ratio of time spent delivering orders to a total amount of orders.

Avg time deviation in orders

The difference between the actual and estimated average time for delivery of an order.

Order's avg mileage (actual)

The ratio of a distance covered by a courier to a total amount of orders.

Order's avg weight

The ratio of the total weight of orders to their total number.

Order's avg volume

The ratio of the total volume of orders to a total amount of orders.

Order's avg cost

The ratio of the total cost of orders to a total amount of orders.

Avg fuel consumption for an order

The ratio of the total amount of fuel consumed to a total amount of orders.

Orders' estimated mileage

The total distance calculated by the system for the delivery of orders.

Orders' actual mileage

The total distance covered by a courier delivering orders.

Fuel consumed in orders

The total amount of fuel consumed while delivering orders.

Orders' total weight

The overall weight of all created orders.

Orders' total volume

The overall volume of all created orders.

Orders' total cost

The overall cost of all created orders.

Moreover, the following data may be included in the statistics for orders:

  • Percentage of orders visited in time;

  • Percentage of orders visited late;

  • Percentage of non-visited orders;

  • Percentage of orders fulfilled in time;

  • Percentage of orders fulfilled late;

  • Percentage of orders visited without status;

  • Percentage of orders rejected.

If the report is executed not for the unit, then, depending on the type of the report template, the statistics include the data listed below.

Report template type

Statistics data

Unit group

Statistics: Report; Group; Interval beginning; Interval end; Report execution time.

User

Statistics: Report; User; Interval beginning; Interval end; Report execution time;

Logins: Time spent on site; Logins count.

Driver

Assignments: In movement; Idling;

Statistics: Report; Driver; Interval beginning; Interval end; Report execution time;

Orders: Total orders; Orders visited; Orders visited in time; Orders visited late; Non-visited orders; Orders fulfilled; Orders fulfilled in time; Orders fulfilled late; Orders visited without status; Orders rejected; Percentage of orders visited in time; Percentage of orders visited late; Percentage of non-visited orders; Percentage of orders fulfilled in time; Percentage of orders fulfilled late; Percentage of orders visited without status; Percentage of orders rejected; Order's avg time (estimated); Order's avg time (actual); Avg time deviation in orders; Order's avg mileage (actual); Order's avg weight; Order's avg volume; Order's avg cost; Avg fuel consumption for an order.

Trailer

Statistics: Report; Trailer; Interval beginning; Interval end; Report execution time.

Resource

Statistics: Report; Resource; Interval beginning; Interval end; Report execution time; SMS sent; SMS available.

Retranslator

Statistics: Report; Retranslator; Interval beginning; Interval end; Report execution time.

Route

Statistics: Report; Route; Interval beginning; Interval end; Report execution time.

Group of drivers

Assignments: In movement; Idling;

Statistics: Report; Group of drivers; Interval beginning; Interval end; Report execution time.

Group of trailers

Statistics: Report; Group of trailers; Interval beginning; Interval end; Report execution time.

Passengers

Statistics: Report; Passenger; Interval beginning; Interval end; Report execution time.

Group of passengers

Statistics: Report; Group of passengers; Interval beginning; Interval end; Report execution time.


The number of text messages that are displayed in the fields of the Resource template does not depend on the interval of report execution. The information is displayed for the period corresponding to the Reset option on the Services tab of the tariff billing properties.


As a rule, for all of the above points, you can make more detailed reports in the form of tables or charts.


V 1.0.0