The Statistics table consists of selected columns and their values.
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 analyzed 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 during the 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 |
---|---|
Time in trips | 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. |
Toll roads mileage | The distance that a unit travelled during the trip on the roads on which the Platon system is used. |
Toll roads cost | The sum of money (in RUB) for the toll roads mileage calculated on the basis of the covered distance and the Platon tariff. |
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. |
Utilization cost
Column | Description |
---|---|
Total utilization 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 | Bindings: 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.