Disclaimer: features differ based on Subscription Plan
The following settings are available in this section:
These settings are universal for all the table types. However, individual parameters can be applied to some of them, which is described for each table separately.
Some tables have fields obligatory for submission. For instance, events should be marked in the Chronology table. The Settings tab of such tables and the required fields or blocks in it are marked with a red asterisk.
Detalization
Reports with grouping can be extended using the detalization option. Detalization gives an opportunity to move to a final level of nesting (date and time). To view the final level of nesting, you can open (‘+’ at the beginning of the line) all the previous levels one-by-one, or click on the corresponding level of nesting.
We can add detalization in the report (check the corresponding box in the table parameters), suggested below as an example of grouping and sorting use. Since in this example we already have grouping by years, months and dates, the detalization will allow us to expand the level of nesting right before the time of the event (hours, minutes, seconds).
It should be noted that sorting is applied to the nested level. Since the detalization is the final level of nesting, you can also set the sorting for detalization in the list of groupings in a similar way.
The detalization function is applied only to the grouped tables, not the detailed ones. The exception is the reports on groups of units, drivers, trailers, and passengers, as the grouping by units is provided in them by default.
Row numbering
Numbering is an additional (always the first) column and can be added to the table of any type.
If grouping is used in the table, numbering becomes multilevel. The main level is the numbering of the main lines with the help of integers. The nested level is the numbering of hidden lines according to the number of the main line — point — number of the nested line scheme.
Total
This option allows you to add the last line that contains the resulting data: the total duration of a certain state, the total number of registered events, the maximum, minimum, or average arithmetic value, and so on
In online reports, the Total line is always at the bottom of the window, regardless of the number of pages in the table and the position of the scrollbar.
The Total line does not display information for fields with text or another type of data which cannot be summarised. The information for the data on location is not displayed either, except for the information about the initial and final location in reports on units. For the initial location, the one that was detected first at the report interval is displayed; for the final location, the one that was detected last.
Time limitation
This function allows indicating which time intervals, days of the week, days, months must be included in the report. For instance, if you check only the working days of the week and working hours or only odd days of the month, etc., only they will be included in the report.
There are two time-limiting algorithms, which depend on the Cut off intervals options.
If the option is not activated, then the state (for example, the trip) that started within the specified interval, but ended beyond its limits, does not terminate. As a result, its duration is fully included in the report.
If the option is activated, then the state (for example, the trip) that started inside the interval, but ended beyond its limits, terminates. As a result, the report includes only its duration within the specified interval, and the rest is ‘cut off’.
Example
The interval from 9:00 to 18:00 is selected as the time limitation interval. Two trips were registered: the first - from 7:50 to 12:00, the second - from 13:00 to 18:20.
According to the first algorithm (the Cut off intervals option is not activated), only the trip that started within the time limitation interval will be included in the report as a whole. That is, in the report, we get one trip lasting from 13:00 to 18:20.
According to the second algorithm (the option the Cut off intervals option is activated), the report will include two trips that are on the specified interval - from 9:00 to 12:00 and from 13:00 to 18:00.
To apply a limit equal to the whole day, you need to set the interval from 00:01 to 23:59.
Incomplete interval
The Incomplete interval option does not apply to all intervals of the table, but only the last (trips, sensor operation, etc.), since its ending does not always coincide with the end of the reporting period. To display this interval, the following options are provided.
Additional parameters
The Calculate fuel parameter is available only for the Summary table. Depending on the selected method, the report takes into account the initial and final fuel levels within certain intervals, which influences the calculation of fuel consumption. In the drop-down list, the following methods are available:
| Method | Description |
|---|---|
| For whole interval | The initial and final fuel levels are taken into account at the beginning and at the end of the reporting interval, respectively. You can get the same result using the Statistics table. |
| In trips | The initial and final fuel levels in the intervals of trips are taken into account. You can get the same result using the Trips table. |
| In engine hours | The initial and final fuel levels in the intervals of engine hours (that is, in the intervals of engine operation) are taken into account. You can get the same result using the Engine hours table. |
In tables where the duration is encountered, you can select the format for displaying it. The following options are available.
V 1.0.0