When executing most tabular reports in the system, time intervals corresponding to the table type are retrieved from the unit history. For example, the intervals refer to the unit trips in a report on trips, while in a report on geofences, the intervals refer to the unit being within a geofence. You can apply filtration to these intervals on the basis of certain parameters. For example, the report can show only those trips that lasted longer than the specified time, or only those geofence visits during which the vehicle was parked.

You can see the Interval filtration section on the Settings tab of the table properties. The available filters, that is, the parameters on the basis of which filtration is carried out, depend on the table type.

You can apply several filters simultaneously. To change the order in which the filters are applied, click on the icon and drag the list items above or below.

All the possible filters are described in detail below.

Custom sensor masks

In this filter, you can specify the masks of custom sensors which should be taken into account when running the report. The filter is available in the Geofences table.

Custom sensor name

The filter allows you to specify the name of a custom sensor, the value of which can be displayed in the Geofences table in the unit group report in following report columns:

• Avg value of custom sensor;
• Min. value of custom sensor;
• Max. value of custom sensor;
• Final value of custom sensor.

In the Custom sensor name field, specify the full name of the custom sensor the value of which you want to see in the report. To specify the names of several sensors, click Add custom sensor name. 

Driver

Not applicable in the system.

Duration

This filter consists of the Min duration and Max duration fields where you can specify the minimum and maximum duration of the intervals to be shown in the report. The maximum allowed value for this filter is 999 h 59 min 59 s (about 41 days and 16 hours).

Example. A value of 10 minutes is indicated in the Min duration field. A report on trips is executed. All the trips lasting 10 minutes or more will be included in the report.

Engine hours

Here in the Min engine hours and Max engine hors fields, you can specify the minimum and/or maximum duration of engine hours required for the interval to be included in the report. The maximum allowed value for this filter is 99 h 59 min 59 s (about 4 days and 4 hours). 

The duration of the engine hours is determined by the sensor of engine hours. You can specify its name or mask in the Engine hours sensor filter.

Engine hours sensor

In this filter, you can specify a name mask for the engine hours sensor in the Name mask field. The mask is used for the Initial engine hours and Final engine hours columns of the Geofences table, and for the Engine hours filter, if this filter is enabled.

Geofences/Units

The filter allows you to see those intervals within which the unit was inside or outside of the selected geofence or area around the selected unit.

By default, the intervals are shown entirely. To see only those parts of the interval during which the unit was inside or outside of the geofence/unit area, enable the Retrieve intervals option.

The filter section consists of two lists: the list of geofences and the list of units. Above each list, there is a dynamic search by item name.

For each list item, you can specify one of three statuses:

• : not to take the item into account;
• : display the intervals within which the unit was inside this geofence or unit area;
• : display the intervals within which the unit was outside this geofence or unit area;

For units, you can specify the radius of the area around them, that is, how close the unit on which the report is executed should be to these units in order for the interval to be included in the report.

To select all the items in the list, hold Ctrl while selecting them. If a group is marked, then all the units from the group are considered selected. In this case, an interval is shown in the report if any of these unit areas were visited during it.

Mileage

Here in the Min mileage and Max mileage fields, you can specify the maximum and/or minimum mileage required for the interval to be included in the report. Fractional values are allowed, with a point as a separator.

Parkings

The filter allows you to see only those intervals withing which parking periods were detected (With parkings option), or only those intervals within which there were no parking periods (Without parkings option). Parking periods are detected according to the settings in the trip detector. See the detailed description here.

If the With parkings option is selected, you can specify the minimum parking duration in the Min duration field in order for the interval to be included in the report. If the Sum up intervals option is enabled, the duration of all the parking periods within the interval is summed up and compared with the specified minimum duration.

Example. A report on geofence visits is executed. You want the report to show only the visits during which the unit was parked. A value of 10 min. is specified in the Min duration field. The unit had been parked inside the geofence for 5 and for 7 minutes. If the Sum up intervals option is disabled, the geofence visit won't be included in the report. If the option is enabled, the visit will be shown in the report because the total parking duration was 12 minutes and the minimum duration requirement was met.

Sensors

This filter allows you to see the intervals within which a digital sensor was on or off.

The following options are available for the filter:

Sensor masks

Here you can specify the masks of the sensors which should be taken into account when executing the report. The specified masks influence:

• Sensors filter;
• values in the Counter, Initial counter, Final counter columns;
• custom sensor values if the Custom sensor masks filter is not used.

The mask of the engine hours sensor is specified separately in the Engine hours sensor filter.

Speed range

Here in the Min speed and Max speed fields, you can the minimum and/or maximum unit speed required for the interval to be included in the report.

If you want the report to show only those periods during which the speed met the specified conditions, activate the Retrieve intervals option.

Stops

The following options are available in the filter:

The intervals themselves are shown entirely.

Trailer

Not applicable in the system.

Trips

The following options are available in the filter:

Example. You execute a report on geofence visits and want the system to ignore the false coordinates sent by the unit while parked, so that the visit is not divided into several visits. For this purpose, enable the Trips filter and select the With trips option.