Intervals Filtration

Intervals Filtration

Several tables are supplied with additional parameters to filter intervals. There you can set conditions to select information to be displayed in the resulting report. These conditions affect reports that concern selecting intervals from the collection of messages. These reports are: Counter sensors, Digital sensors, Geofences, Engine hours, Parkings and Stops, Rides and Unfinished rides, Speedings, Trips, and others.

The set of filtration parameters varies depending on table type. The following parameters are possible: duration, mileage, engine hours, speed range, trips, stops, parkings, sensors, driver, trailer, fuel fillings and thefts, geofences. Adjusting these parameters will limit the scope of intervals getting to the report. For example, you can indicate the minimum duration and minimum mileage for the trips to be displayed. Alternatively, you can query visited geofences with a stop at least 10 minutes in them. Note that all the filters except for the mileage one work with integer values.

Counter sensor value range
This filter can only be used for the Counter Sensors and Fuel Traffic tables. It provides a possibility to generate a report for a period of time on which messages' values received correspond to the indicated value range.

Incomplete interval
This filter affects only the last interval in the report. In many cases, reported period ends and the last interval (trip, sensor operation, etc.) still continues. You can choose one of the following options to deal with such unfinished intervals:

  • Show and cut off: show the incomplete interval and consider that it ends with the last message within the reported period;
  • Do not show in report: do not show the incomplete interval in the report;
  • Show and mark as incomplete: the incomplete interval will be shown and will have Unknown as the end time.

Duration
Minimum and/or maximum duration of the interval.

Additional parameters
In the Additional parameters filter, which is available for the Eco driving table, you can activate the Show all trips function. As a result, the report for units with configured eco driving parameters will include all trips, not just the trips with violations.

Mileage
Minimum and/or maximum distance traveled in the interval. Either integer or non-integral values can be indicated as a filter. For non-integral values use dot as a delimiter.

Engine hours sensor
Enter name mask for engine hours sensor. It affects calculations in reports which contain any information on engine hours as well as engine hours filter below.

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

Event filter
This filter can be used for the 'Events' table only. It provides the possibility to filter the table by event mask. Moreover, by indicating the 'Custom events only' flag, an event report table will contain custom events only, while absence of the flag will lead to having both custom events and online notifications in the table.

Speed range
Indicate minimum and/or maximum speed to be considered. It means that only those intervals will be displayed in the report which contain at least one message with speed falling into the range. But more helpful might be retrieving intervals. If you check the Retrieve intervals box, the report will focus on intervals where all speeds fall into the range.

Trips
This filter is used to show either the intervals that include trips or the intervals that do not include any of trips.

Stops
Tick the checkbox and choose one of the two possibilities: With stops or Without stops. Then in the resulting table, only intervals that meet the given condition will be shown. If the Stops option is not selected, then all intervals are displayed regardless if there were any stops or not.

Parkings
The settings are similar to those for stops. In addition, you can indicate the minimum parking duration. For instance, you can query geofences where there is a parking of a specified time (the Minimum duration flag). Besides, the parking time can be summed up (the Sum up intervals flag). That means the geofences where the total parkings make up the specified time will be displayed.

Sensors
The intervals where there are messages with sensor on or off can be selected. In addition, you can indicate minimum and/or maximum time of sensor's on/off state. Like in parkings, the duration can be summed up (the Sum up intervals flag). Besides, the intervals of on/off state can be retrieved, and each of them can be presented as a separate row of the table (the Retrieve intervals flag). To indicate a certain sensor to be controlled, type its mask below. If you select several, then the intervals which contain points with all these sensors on/off (simultaneously) will be selected. If no masks are specified, then all sensors will be considered.

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

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.

Violation
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.

Driver
This filter allows selecting intervals with a certain driver or driver group or without them. Choose the option With driver and specify the driver's name mask. The resulting table will contain only the intervals with the corresponding driver — it does not matter whether this driver is at the beginning, in the middle, at the end or in all course of the interval. If the option Driver group is chosen, while generating a report only those intervals that have some driver belonging to a group (the group’s name mask can be indicated as well) will be analyzed. In addition, you can enable the option Retrieve intervals to get only those segments that contain the specified driver or group from the scope of intervals.

If the option Without driver is selected, the resulting table will consist of intervals which contain segments without any drivers or driver groups. Those segments can be retrieved as well.

Trailer
This filter works in the same way as the previous one, but it allows to filter intervals according to presence or absence of a trailer assigned to a unit.

Fuel fillings
Intervals with fillings or without fillings can be displayed in the table. If the first case is chosen, then you can additionally indicate max and min filling volume. Fillings can be summed up. In this case, the indicated filling volume will be applied to the total of fillings found.

Fuel thefts
Intervals with fuel thefts or without thefts can be displayed. If the first case is chosen, then you can additionally indicate max and min theft volume. Like fillings, fuel thefts can be summed up.

Geofences/Units
The filter is divided into two parts — geofences and units. In the upper part you can select geofences to be analyzed for the report. You can focus on unit activity in or out of a geofence. To put a geofence under control, move the marker from None to In or Out against a required geofence.

To facilitate the process, you can indicate flags for groups of geofences (displayed in square brackets). Indicating the flag for a group of geofences equals to indicating flags for every geofence of this group. Note that number of geofences in a group is dynamic (adding to/deleting from groups of geofences), and notifications come considering this dynamics.

In the same way you can choose units (they are considered as 'moving geofences'). In this case, indicate radius for these units. Thus, you can get information about unit activity in or out of the area of selected units. Only units to which you have Query reports or messages access are displayed here. To quickly find a necessary geofence or unit, use the dynamic filter. To select all items at once, use the <ctrl> key.
In addition, you can enable the option Retrieve intervals to retrieve only segments inside or outside selected geofences or units.

While determining the time of intersection of a unit with geofences or other unit areas, the option Maximum interval between messages from this unit's properties is taken into account.

Each of described above limitations can be applied either independently or along with other limitations. If the option Retrieve intervals (in the Sensors or Speed sections) is combined with other conditions, then the filtration by other conditions is applied after retrieving the appropriate intervals. Also, for the Fuel Traffic table it is possible to display only the units with registered fuel fillings. To do this, check the Include only units with tank fuelling box.

The above described filters can be used either independently or in combination with each other. Each filter is applied directly to the indicated time interval, and a generated report shows a value meeting the parameters of all the filters used.

Merge intervals condition
This filter is available for the Counter Sensors and Fuel Traffic tables. If the timeout between the intervals is smaller 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 parameteres is executed.



    • Related Articles

    • Intervals Filtration

      Most table reports in the gTrack 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 ...
    • Filtration

      Note: Ellipsis (…) substitutes 'Unit properties → Fuel consumption' is option paths. Two options are connected with filtering: Option: 'Filter fuel level sensors values'; Option: 'Filtration level (0..255)'. Filtration enabling and filtration level ...
    • Service Intervals

      Required access: View service intervals — to view this tab and its contents; Create, edit, and delete service intervals — to create new intervals, and to edit and delete existing ones. On the Service Intervals tab of the Units Properties dialog, you ...
    • Incorrect Intervals of Engine Hours

      In the table of engine hours, incorrect intervals are detected. What can I do? Possible reasons and how to eliminate them: If engine hours are detected by ignition sensor, the reason can be that data coming from this sensor is incorrect. Check sensor ...
    • Map Output

      In the 'Reports' panel, the map can be scaled and moved in the same way as everywhere else: zoom, move, apply tools, change the map source, etc. Even being in the 'Reports' panel you can still track your units. Besides, some specific map options can ...