ARRIVE First Mile Dashboard
Executive Dashboard for ARRIVE First Mile Operations.
Features
- 📊 Executive KPIs
- 📈 Interactive Charts
- 🌐 Live Google Sheets Integration
- 🔄 Google Apps Script API
- 🇪🇬 Arabic (RTL) / 🇺🇸 English (LTR)
- 🔄 Auto Refresh
- 📋 Executive Summary
- 📊 Data Quality Analysis
- 📄 Export Reports
Architecture
Google Sheets
↓
Google Apps Script
↓
JSON API
↓
ARRIVE First Mile Dashboard
Project Files
All files sit in one flat folder — index.html loads every script below with a relative <script src="..."> tag, in this order:
index.html — main dashboard page (open this to run the dashboard)config.js — the only file you edit: Google Apps Script URL + refresh settingsarrive-data-service.js — fetch/retry/timeout/auto-refresh layeri18n.js — Arabic/English translation stringsformatters.js — number/date formatting helperstables.js — data-quality and salary reference tablescharts.js — SVG chart rendering (no canvas/rasterization)filters.js — canonical row-filtering engineaggregations.js — KPI/summary aggregation logic (includes the Phase 6A pickupDays helpers)filter-ui.js — filter panel UI wiringcomparison.js — period-over-period comparison enginereportData.js — Management Report data builderreportPreview.js — Management Report HTML renderingreportPdf.js — native browser print/PDF exportdashboard.js — orchestrates all of the above (loaded last)logo.png — ARRIVE logo assetCode.gs — Google Apps Script backend (paste into your Google Sheet's Apps Script editor — see SETUP_GUIDE.md)SETUP_GUIDE.md — technical setup instructions (English)OPERATING_GUIDE_AR.md — دليل تشغيل عملي بالعربيةCHANGELOG_FINAL.md — what changed in this FINAL package vs. the previous delivery
Deployment
Static files — host the folder anywhere that serves static HTML (Vercel, GitHub Pages, an internal server, Google Drive, or opened directly via index.html). See SETUP_GUIDE.md / OPERATING_GUIDE_AR.md for details and browser/CORS notes.
Configuration
Update the Apps Script URL inside config.js — it is the single, only place the API URL lives.
pickupDays (Phase 6A)
The backend (Code.gs) now also returns an independent pickupDays dataset (per-request pickup dates, for a future "Pickup Days" report). The frontend reads it safely and defaults to an empty list if it's missing from an older deployment — rows and every existing chart/table/filter/report are unaffected. See SETUP_GUIDE.md → "Phase 6A — pickupDays" for details.
Version
Current Version: v2.2 (Phase 6A — FINAL)
