OnTime Dynamic Dashboard

Highest daily hops for one aircraft on one flight number

Track the most leg-dense same-flight-number itineraries in the live OnTime dataset, keep the lead route anchored in the KPI strip, and redraw the itinerary map and stop details as you switch rows.

Waiting for token and query execution.
Visual mode: dynamic
Visual type: html_map
Enter a JWE token in the footer controls or rely on the locally stored one to fetch the live top-hop itineraries from ClickHouse. The dashboard shell stays hidden until the primary query succeeds.
0 rows loaded

Lead Itinerary Map

Airport-coordinate enrichment will populate route geometry after the primary result set loads.
Waiting for airport-coordinate enrichment for the top-ranked itinerary.

Route Sequence And Legend

Stop-by-stop progression and map semantics for the selected itinerary.
Lead selected route
Airport stop markers
Degraded map or missing coordinates
Peer itinerary comparison bars

    Repeated Route Comparison

    Compare the selected itinerary with matching and nearby hop leaders from the fetched result set.

      Ranked Itinerary Table

      Click any row to redraw the map and refresh the route detail panel for that itinerary.
      Rank Aircraft ID Flight Number Carrier Date Hops Repeated Route Route

      Query Ledger

      Primary and enrichment SQL are recorded here with live execution state, row counts, and any degraded map notes.