This is an old revision of the document!

Intervals Filtration

Most table reports in the Wialon system involve retrieving time intervals which meet certain criteria from the unit's history. These are reports on trips, parkings, stops, engine hours, rounds, geofences and visited streets, reports on the operation of sensors and speeding, and others. For such reports, additional filtering options are provided, which specify the conditions for displaying information in the table.

Available parameters of filtration vary depending on the type of report and allow you to limit the range of intervals that fall within it. For instance, the report does not include trips, stops or speeding intervals, if their duration is less than the minimum duration specified in the intervals filtration. It is also possible to display only visited geofences in which parking has been detected or during which the sensor was turned on. All possible filters are described below.

Filters can be used both separately and in combination with each other. Each filer is applied directly to the time interval under consideration, and the report displays the value that combines the results of all the filters used.

:!: All filters except the mileage filter work only with integer values.

Additional parameters
The filter is available for the Eco driving table. When the Show all trips option is activated, all trips, not just trips with violations, are included in the report for units with customized eco-driving parameters.

Counter sensor value range
This filter can only be used for the Counter Sensors and Fuel Traffic tables. It allows to display in the report the intervals at which the messages with values that are within the specified limits are received.

Custom fields masks
The filter is available for the Custom fields table. Here you can indicate the masks that must be applied to the names of the custom fields and their values.

Custom sensors masks
In the filter you can indicate the masks of custom sensors, which must be taken into account when generating a report on digital sensors.

The filter allows to display the intervals at which the unit did not have a driver or there was a certain driver or group of drivers. If you want the report to include only the intervals at which a particular driver controlled the unit, select the With driver option and specify the mask of the driver's name in the field below. In this case, all intervals with the driver are displayed, regardless of whether the driver was present at the beginning, end, middle or along the whole interval. If the Driver group option is selected, only the intervals at which the vehicle was driven by any driver in the group (the mask of the name can also be specified) are analyzed when generating the report. In addition, you can activate the Retrieve intervals option to remove only the segments with the specified driver or group.

If the Without driver option is selected, the table displays only the intervals at which there are segments without drivers. These segments can also be retrieved.

Duration\\In the filter, you can specify the minimum and/or maximum duration of the interval.

Engine hours
The minimum and/or maximum duration of engine hours. In addition, the engine hours sensor mask can be specified in the Engine hours sensor filter.

Engine hours sensor
In this filter, you can specify a mask for the name of the engine hours sensor. It affects the calculation of engine hours in the tables which have the corresponding columns, as well as the engine hours filter if it is turned on.

Event filter
This filter is only available for the Events table. If it contains an event mask, only the events that satisfy it are included in the report. When the option Custom events only is activated in the filter, only custom events fall into the report. If the option is not activated, in addition to custom events, the fields with online notifications are also displayed in the report.

Fuel fillings
The filter allows to display intervals with or without fuel fillings in the report. In the first case, you can additionally specify the minimum and maximum volume of fillings, and also activate the Sum up fillings option. Summing up assumes that only those intervals fall into the report, the amount of fillings on which falls within the specified limits.

Fuel thefts
The filter allows you to display in the report intervals with fuel thefts or without them. In the first case, you can additionally specify the minimum and maximum amount of theft, and also activate the Sum up thefts option. Summing up assumes that only those intervals where the amount of thefts falls within the specified limits get into the report.

This filter is divided into two parts. In the first one, you can specify the geofences by which the intervals should be filtered. In order to consider the position of the unit in any geofence or outside of it, set the radio button to the left of its name in the list from the None position to the 'Inside' or 'Outside', respectively. In addition to individual geofences, you can also specify their groups. It is the same as specifying each geofence which belongs to the group. :!: The number of geofences in a group is dynamic, that is, it changes when you change the list of geofences which belong to it. These changes are taken into account when building the report.

In the second part of the filter, units are selected in the same way. Thus, it is possible to get the intervals of the unit's location inside or outside the zone of another unit. The size of the zone is defined by the Radius parameter. Only those units to which you have the Query messages or reports access right are displayed.

To quickly search for geofences and units in the list, the dynamic filter is available. To select all units in a column, hold the Ctrl key.

When determining the time of intersection of a unit with geofences or zones of other units, the Maximum interval between messages option is taken into account from the Advanced tab of the unit's properties.

The Retrieve Intervals option is available in the filter. It allows you to remove the segments inside/outside of the specified geofences or units from the intervals.

In the filters by geofences/units in the Sensors section for the Fuel Traffic table, the Include only units with tank fuelling box option is available. It allows you to display in the report results only those units that were near the unit on the specified interval and had registered fillings.

Merge intervals condition
In this filter, which is available for the Counter Sensors and Fuel Traffic tables, you must specify a timeout. If you generate a timeout between some intervals less than the indicated one, the intervals are merged. In this case, firstly the merger is carried out, and then the filtration on the basis of remaining parameters is executed.

In the filter, you can specify the minimum and/or maximum mileage within the interval. It can use both integer and fractional values. Use a period as the separator for fractional values.

The filter allows you to display only those intervals within which there were parkings, or only those within which there were none. Select the With parkings or Without parkings option from the drop-down list. In the filter, you can also specify the minimum length of parking. As a result of using this option, the report on geofences, for example, displays only such visited geofences in which a parking period of at least the specified duration was detected. The Sum up intervals option allows you to summarize the time of parking, that is, show in the report, for example, only those geofences, the total number of parkings in which was not less than the specified time.

The filter allows to display intervals in the report table with the sensor turned on or off, and, additionally, specify the minimum and/or maximum duration of such intervals. In order for each interval to be shown in a separate row of the table, check the Retrieve intervals option. Intervals can also be summed if the maximum and/or minimum duration of the sensor on/off state is specified. To specify a certain sensor, whose turning on/off should be taken into account, specify its mask in the Sensors mask filter. If several masks are specified, only those intervals at which all these sensors were simultaneously turned on/off are selected. If the sensor masks are not specified, the report takes into account all sensors of the unit.

:!: The intervals filtration of the With sensor on type works only for the digital sensors.

Sensors masks
Here you can enter the sensor masks which will be considered when generating the report. Sensors masks affect the Sensors filter, Counter column, and information on fuel (if any of these options is selected in the report template). Note that the engine hours mask is indicated individually in the corresponding field.

In the filter, you can set the minimum and/or maximum speed within the interval. As a result, the report shows the intervals at which the speed that falls within the given limits is met at least once. If you want only those segments within which the speed does not leave the specified limits to get in the report, activate the Retrieve intervals option in the filter.

This filter allows you to display only those intervals at which there were stops or only those at which there were no stops. To do this, select either the With stops or Without stops option from the drop-down list. If the filter is not used, the report displays all the intervals, regardless of whether there were any stops or not.

Intervals filtration by the presence or absence of trailers assigned to the unit. Works similarly to the filtration by the driver.

The filter allows you to display only those intervals that intersect with trips (it is not required for the entire trip to be a part of the interval) or only those that do not intersect with the trips. It is convenient to use the Trips filter, for example, in the report on geofences: in order to cut off excess visits to the same geofence during the unit's parking (when the coordinates are unsteady), select the With trips filter.

The filter is available in the Eco driving table and allows to enter the name masks of the violations that are to be taken into account while generating a report.

Follow us on Facebook Gurtam Wialon Twitter Gurtam Wialon   |   Copyright © 2002-2020 Gurtam