Statistics

Statistics is a special table that includes summary data for the selected report period. It provides information about the report as a whole, such as the start and end of the report interval, number of messages, unit name, time zone, report execution time, and other data that depends on the report template type.

If the report is executed for a unit, then statistics can include data from other tables, such as Engine hours, Trips, Eco driving, and others. See the complete list of statistics rows for different report types in the sections Rows in the “Statistics” table for report on units and Rows in the “Statistics” table for other report types.

Statistics consists of the selected rows and their values.

To add statistics to a report template, follow the steps below:

1. Open the properties of the report template to which you want to add statistics.

2. On the Contents tab, click on the Statistics button.
   

3. On the Columns tab, select the necessary rows, that is, the data you want to see in the table. Next to the row name, the table that serves as the data source for this row is displayed. See the description of all rows in the sections Rows in the “Statistics” table for reports on units and Rows in the “Statistics” table for other report types.
   For a quick search, use the dynamic search, which works by row name and source table.

   If the table doesn’t have the row you need, you can create your own based on existing columns or other data using the Custom column button. See the Tables page for detailed information.

   

4. If necessary, edit the row names:

   • To rename the row, click on the row and make changes.

   • To return to the original name, click on the icon .

5. If necessary, configure the order of rows. To do this, drag them using the icon next to their names.

6. On the Settings tab, select the format in which time intervals should be displayed. See the description of the Duration format option on the Settings page.
   

7. If necessary, configure interval filtering in the table that serves as the data source for the selected rows. This may be necessary if you don’t want to include certain table intervals in the final calculation. See more details in the section Filtering intervals in source tables.

8. Click OK to save the changes.

As a result, the statistics table is added to the content list of the report template.

The Statistics table is always first in the list in the report template and can’t be moved.

Source tables are the tables that provide data for calculating the value of a statistics row. The name of the source table is shown next to the row name on the Columns tab.

Filtering allows you to select specific table intervals that should be considered for calculating the final value in the statistics row. Intervals depend on the table type. In the Engine hours table, intervals are engine operation periods based on the engine hours sensor, in the Eco driving table — violations, and so on. For example, you can configure the table to show only those engine operation periods during which the vehicle was parked or only those violations that lasted longer than 1 minute.

In statistics, interval filtering is available only for reports of the Unit type.

To configure interval filtering in statistics, follow the steps below:

1. Go to the Settings tab in the properties of the Statistics table.

2. Click on the icon next to the name of the source table.

3. In the Filtering parameters window, configure the conditions for including intervals in the table. See the description of all filters on the Interval filtering page.
   If the report template already has a table with filtering configured, you can apply it to the Statistics table. To do this, select this table at the top of the window and click Load.
   

4. If necessary, configure the order in which filters should be applied. To do this, click on the icon in the Interval filtering row and drag the filters in the list using the icon .

As a result, the values of statistics rows associated with this table are recalculated according to the configured filtering.

If you have configured filtering for a table, but rows from it are not selected on the Columns tab, then these settings are not applied and are not saved.

Tables for which interval filtering can be configured in statistics:

• Counter sensors
• Eco driving
• Engine hours
• Events
• Fuel drains
• Fuel fillings and battery charges
• Images
• Maintenance
• Orders
• Parkings
• Speedings
• Stops
• Trips
• Unit latest data
• Violations
• Visited streets

Below are the rows available for adding to statistics for reports of the Unit type. They are grouped by source table type.

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

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 not visited but confirmed orders
• Percentage of visited but not confirmed orders
• 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.

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.