Reporting

AdaTrack's Reporting Module allows you to generate professional, structured summaries of your telemetry and geospatial data. While the Live Map and Statistics modules are built for exploration, Reporting is designed for documentation, compliance, and periodic review.

Key Capabilities

• Custom Templates: Define exactly which devices, profiles, and telemetry fields to include in your reports.

• Stats Chart Blocks: Embed any Saved Chart Configuration as a visual block directly into your reports.

• Geospatial Insights: Automatically calculate metrics like total distance traveled, average speed, and time spent within specific geofences.

• Automated Scheduling: Set up reports to generate and send automatically on a daily, weekly, or monthly basis.

• Multi-Channel Delivery: View reports in your browser, download them as PDF files, or have them emailed directly to your team.

• RBAC Support: Use System Templates provided by administrators or create your own User Configurations.

Creating a Report Configuration

A Report Configuration is a template that defines the structure and schedule of your reports.

1. Navigate to the Reports page and click Create Configuration.

2. Scope: Select the devices or device profiles you want to include.

3. Add Chart Blocks: Select any from your "Saved Chart Configurations" (created in the Statistics explorer) to add visual intelligence.

4. Fields: Choose the telemetry keys (e.g., temperature, battery) and the aggregation type (Average, Max, Min, or Sum).

5. Geospatial Metrics: Toggle "Include Distance Traveled" or "Geofence Analysis" to add spatial intelligence to your report.

6. Schedule: Choose a periodicity (Manual, Daily, Weekly, Monthly) and enter the email recipients.

Types of Reports

1. Telemetry Summary (with Charts)

Focuses on sensor data trends. Now enhanced with Chart Blocks to show battery health or environmental trends (cold chain, agriculture) over a large fleet alongside raw data tables.

2. Trip & Activity Report

Utilizes geospatial analytics to summarize movement. Ideal for logistics and fleet management. It includes:

• Start and end locations for the period.

• Total distance covered (km/miles).

• Maximum and average speeds.

• Idle time vs. moving time.

3. Compliance & Geofence Report

Lists all geofence entry and exit events for a specific period. Essential for security and verifying that assets stayed within authorized zones.

Ownership and RBAC

Reports now feature ownership badging:

• System (Badge): These are pre-defined templates created by administrators for common operational needs.

• User (Badge): These are your custom-created report configurations.

Report History

Every generated report is stored in the Report History tab. Here you can:

• View the status of ongoing generations.

• Download historical PDF files.

• Re-send reports to additional email recipients.

Technical Details

• Data Processing: Reporting queries use TimescaleDB's continuous aggregates where possible to ensure fast generation even for large datasets.

• Spatial Calculation: Distances are calculated using PostGIS's ST_Length on a reconstructed path of GPS points.

• Consistency: The Reporting module uses the same query engine as the Statistics V2 module, ensuring that the data you see in your dashboards matches your reports exactly.

Best Practices

• Use Chart Blocks: Visual summaries make reports much easier to digest. Combine a "Battery Trend" chart with a raw data table for a comprehensive health report.

• Schedule during Off-Peak Hours: While AdaTrack is performant, it's good practice to schedule large monthly reports for early morning hours.

• Test with "Manual Run": Use the Run Now button on your configuration to verify the data and layout before setting up an automated schedule.