Summary Reports
Summary Reports

Summary Reports

📖 Afaqy Knowledge Base / AVL / Reports / Summary Reports

CONTENTS
‣
Monitoring
‣
Tracking
‣
Units
‣
Geofences

Summary reports provide an essential overview of operations either by unit or by driver, offering high-level analytics across defined time intervals. These reports are ideal for performance benchmarking, operational summaries, and executive-level insights.

Report Types

  1. Summary Report
  2. Summary by Driver
  3. Summary CAN BUS
  4. No Connections
  5. Last Update

1. Summary Report

Description

Provides a time-based overview of each unit's performance, highlighting operational metrics such as mileage, idle time, engine activity, and sensor readings if available. Additional configuration options enhance the relevance and readability of the report output.

Key Insights

  • Mileage driven per day, week, or month
  • Driving time vs. idle time analysis
  • Mileage vs. Fuel consumption
  • Number of trips and stops
  • Speed profiles and maximum speed reached
  • Total movement time and engine runtime comparison

Report Input

  • Units
  • Fields (mileage, idle time, driving time, trips, max speed, etc.)
  • Summary by (days, weeks, months)
  • Report Duration
  • Duration format (days or hours)
  • Draw Track in PDF: Adds a visual route to the exported PDF if only one unit is selected (optional)
  • Chart to HTML: Adds a visual chart (e.g., Mileage vs. Fuel consumption chart) to the exported HTML (optional)

Data Filters

  • Min/Max Mileage: Focus on specific trip lengths.
  • Time Limitation: Exclude specific periods. When enabled, this feature excludes specific timeframes from the report based on selected hours, weekdays, calendar days, and months.

      • Users can:

    1. Define a time range (e.g., 09:00 to 16:00).
    2. Choose specific weekdays (e.g., Sunday).
    3. Include only certain days of the month, or use quick filters like Odd/Even.
    4. Select specific months of the year.
    5. Click on the Inverse button to treat the selected time ranges as excluded periods instead of included ones.

      6. Use Time Limitation to narrow report data to relevant operating hours or to exclude non-working periods.

image
  • Hide Empty Records: Removes rows with no detected data or offline during the reporting period.
  • Hide Summary Records: Hides summary totals of each selected unit in the Excel export for a more granular look.
  • Mileage from Sensor: Calculates mileage using the installed 'Mileage' sensor instead of GPS if available.

How the report is calculated

  • Mileage is taken from the mileage sensor (if available). If not, it is calculated using GPS coordinates (distance between track points).
  • Idle time is derived from engine on + no motion.
  • Movement time is computed from motion events.
  • Trips and stops are calculated based on ignition and speed thresholds.
  • Time is grouped based on the selected interval (daily/weekly/monthly).

2. Summary by Driver

Description

Summarizes operational activity on a driver-by-driver basis, regardless of which vehicle was used. Designed for evaluating individual driving patterns and workloads.

Key Insights

  • Total distance and time driven per driver
  • Idle vs. active driving breakdown
  • Driver workload and trip distribution

Report Input

  • Drivers
  • Fields (driving time, idle time, trips, stops, etc.)
  • Report Duration
  • Duration format (days or hours)
  • Summary By (days, weeks, months)

Data Filters

  • Time Limitation

How the report is calculated

  • Aggregates data based on driver-unit associations (manual or automated).
  • Totals are computed per driver across all used units.
  • Mileage uses sensor or GPS fallback depending on availability.

3. No Connections

Description

Highlights units that failed to communicate with the server during a selected timeframe, helping identify communication issues.

Key Insights

  • Units with prolonged disconnection
  • Duration since last message
  • Impacted geofences or locations

Report Input

  • Units
  • Geofences
  • Fields (last update, disconnection duration, location, etc.)

Data Filters

  • Status (offline, no signal)

How the report is calculated

  • Compares the last message timestamp against the current system time.
  • Flags units that exceed the user-defined offline threshold.

4. Last Update

Description

Displays the timestamp of the most recent update received from each unit to track responsiveness and spot inactive devices.

Key Insights

  • When each unit was last heard from
  • Operational status at last check-in
  • Location and motion state if available

Report Input

  • Units
  • Geofences
  • Fields (last update, location, driver, etc.)

Data Filters

  • Status (offline, no signal)

How the report is calculated

  • Pulls the most recent server entry per unit.
  • Includes location and motion status from that message.

5. Summary CAN BUS

Description

Focused on vehicles equipped with CAN BUS integration. Provides highly accurate metrics derived from internal vehicle systems.

Key Insights

  • Actual fuel consumption
  • Engine RPM and temperature behavior
  • Accurate odometer and engine hours from vehicle ECU

Report Input

  • Units
  • Fields (route length, engine work duration, fuel efficiency, fuel consumption, etc.)
  • Report Duration
  • Duration format (days or hours)

Data Filters

  • None

How the report is calculated

  • All data is pulled directly from the CAN BUS interface.
  • Raw binary values are converted using decoding algorithms specific to each vehicle model.