Operations Dashboard

PTrack · Employee Transport

Live Reports
☀️ 🌙

Upload Trip Reports

Upload CSV or Excel files from your transport system. One company's data at a time — dashboard will show only that company's data.

📂

Drop Files Here

Drag & drop or click to browse — select any combination of Login, Logout & Summary Reports (CSV or Excel)

Accepted: .xlsx · .xls · .csv · Filename should include: "login", "logout", "detail", or "summary"
📋 How to Upload from PTrack:
1. Go to Reports → Trips Detailed Report (Login) → Download — filename rakha "login_detail" ya "detailed"
2. Go to Reports → Trips Detailed Report (Logout) → Download — filename rakha "logout_detail"
3. Go to Reports → Trips Summary Report → Download — filename rakha "summary"
4. Upload kara — dashboard auto-detect karta filename & column structure varun
5. Tip: Multi-sheet Excel (Login+Logout tabs) → auto-detect by tab names
⚡ Processing Data
Large files may take a moment — browser will stay responsive
Reading files...
📅 Date: to
🔄 Shift:
🕐 Time:
🧑‍✈️ Driver:
— records
🏠Dashboard Overview
Quick snapshot of all operations

📈 Daily Trip Volume Trend

🔵 Login vs Logout Split

🔥Trip Activity Heatmap Calendar
Each cell = one day. Darker green = more trips. Red = problem day (>40% late trips or >15% no-show/cancelled).
Less
More trips   
Problem day (>40% late or >15% no-show/cancelled)

📊 Daily Trip Volume

✅ Trip Status Breakdown

👥 Avg Occupancy per Day

🕐 Trips by Shift Time

📅Select Date for Shift Details
🔍
Trip ID Date Shift Time Driver Vehicle Route Capacity Occupancy Fill % Status Lateness Late Due To

⏱️ Reaching Lateness Distribution

📈 On-Time vs Late Trend (Daily)

🕐 Scheduled vs Actual Office Time

🔍 Late Due To Breakdown

⏰Trip Timing Detail
🔍
Date Shift Driver Vehicle Sched. Office Time Vehicle Reaching Time Reaching Lateness Status Sched. Travel Actual Travel Travel Diff

🏆 Driver On-Time Rate (%)

📦 Driver Trip Count

🧑‍✈️All Driver Performance Cards

🚗 Avg Capacity Utilization by Vehicle

📊 Capacity Fill Distribution

🚌Vehicle Capacity by Trip
🔍
Date Vehicle Code Registration Driver Shift Time Capacity Occupancy Fill % Empty Seats Seats Visual
📦Distance Category Summary

📏 Suggested vs Travelled Distance (km)

⏱️ Scheduled vs Actual Travel Time

📈 Daily Distance Trend

🔀 Travel Time Efficiency (Actual/Scheduled %)

📍Travel Detail Table
🔍
Date Driver Vehicle Shift Sched. Travel Time Actual Travel Time Time Diff Suggested Dist (km) Travelled Dist (km) Dist Diff (km) Efficiency
OTA REPORT
OTD REPORT
DAY-WISE OTA % & OTD % TREND
COMBINED OTA + OTD SUMMARY
Day Wise OTA & Trip Details (LOGIN)
Day Wise OTD & Trip Details (LOGOUT)

🗺️ Top Routes by Trip Count

⏰ Most Late Routes (Avg Lateness)

📏 Distance Efficiency by Route

✅ On-Time Rate by Route

🗺️Route-wise Performance Table
🔍
Route Name Total Trips Completed On-Time On-Time % Avg Lateness Max Lateness Avg Distance (km) Performance
Chart
🔍 Advanced Search
Saved Presets:
⏰ Late Trips ❌ Cancelled ⚠️ No Show ✅ Full Vehicles 😶 Empty Vehicles
📋 Custom Report Builder
1. Select Columns to Include:
2. Apply Filters:
3. Report Options:
💾 Data auto-saved