To add a table to the report template, click on the New table button on the Contents tab of its properties.
In the New table dialog, specify the name and type.
The set of available table types differs depending on the selected type of the report template. The list of tables and their description are presented in the chapters below.
Each type of table has its own set of columns which can be included in it. The list of available ones is shown on the Columns tab after selecting the type of table. To quickly find the required one, you can use a dynamic filter. Select the ones you want to see in the report. To select all the columns, press the Ctrl button and click on any unselected column. Removing a selection from all the columns works in the same way. The identical principle is used in the settings of the reports, where geofences, events, etc. should be selected.
To change the name of the column, click on it with the left mouse button and edit the text. To return the original name of the column, click on the Default icon(the icon is inactive if the name has not been changed).
What is more, the order of the columns can be changed as well. To do this, drag the icon of the double arrow, located to the left of the name of the desired column, up or down.
Some alternative types of reports are available as applications:
- Dashboard: graphical representation of the key performance indicators of the fleet;
- Eco Driving, iDriveSafe: driving quality assessment;
- Tacho View: reports on the drivers’ work, including infringements;
- Sensolator: visual representation and control of the sensor values of the units with reports on units and their groups.
Any number of tables can be added to the template, and the same table can be added to the report several times with different column configurations, data grouping settings, etc.
Adding custom columns
You can add custom columns to all the tables except for Images, Video, and Statistics. They are used to calculate values on the basis of data from other columns, unit parameters, the report interval, and so on. Custom columns can also display text values such as the unique ID, profile properties of the unit, and text values of custom fields.
To add a custom column to the table, follow the steps below.
1. Click on the Add calculator button.
2. Specify the formula for calculating the column value.
You can use the following components in the formula:
Indexes of other columns
Column indexes are shown to the left of column names after clicking on the Add calculator button and don't change regardless of the column position in the list. Indexes are indicated in the CN format, for example, C0, C1, C24, and so on. To add an index to the formula, click on it in the list or enter it manually.
You can add the following unit parameters to the formula:
To add a parameter to the formula, enter its key or select it from the menu which opens after clicking on the three-dot icon.
You cannot use the unique ID together with other components in the formula. Otherwise, a dash is displayed in the custom column in the report.
Unit profile properties
The profile properties of the unit are added to the formula in the profile_field(key) format. You can select them from the menu which opens after clicking on the three-dot icon in the Formula field. In addition to the properties from the Profile tab, you can also find the Unit type property here.
You cannot use profile properties together with other components in the formula. Otherwise, a dash is displayed in the custom column in the report.
Data on the report interval
You can use the following data on the report interval in the formula:
To add this data to the formula, enter the required key or select it from the menu which opens after clicking on the three-dot icon.
To display a custom field value in a custom column, type custom_field(field name) in the Formula field. Instead of the name, you can use its mask. If the names of several custom fields correspond to the indicated mask, the report shows the value of the field that comes first in the list of custom fields in the properties of the object.
You can use constant values formatted as constN where N stands for any number. For example, const-1.5, const10, and so on.
The following mathematical operations are allowed:
|Parentheses of priority|
Parentheses are used to indicate the priority of an operation. For example, in the formula (C44+C54)/const2, the parentheses indicate that addition should be performed before division.
3. Specify the name of the custom column.
4. Indicate the unit of measurement (up to 10 characters).
5. If you use the custom column to calculate duration, select how it should be displayed in the Conversion drop-down list.
- Without conversion. Duration is displayed in seconds.
- Duration format. The Duration format option from the table settings is used. If there is no such option, the result is displayed in the hours:minutes:seconds format.
- Date and time format. The date and time format indicated in the user settings is used.
If the value cannot be converted to the selected format, a dash is displayed in the custom column.
6. Click Save.
The custom column automatically goes to the top of the list. However, you can change its position in the standard way if necessary. Such columns are highlighted in blue and do not have an index.
To edit the created column, click on the icon, column name, formula, or unit of measurement, make the necessary changes and save them.
The value of the custom column in the Total row is calculated in the same way as for other rows, that is, in accordance with the specified formula that uses the values of the column.
For each table, in addition to selecting columns, there are additional settings, located in the same-name tab.
The tab is divided into three sections: