--- a/myway/myway_timeliness_overview.php
+++ b/myway/myway_timeliness_overview.php
@@ -77,8 +77,7 @@
Stop |
1 order by myway_stop";
+ $query = "select myway_stop, avg(timing_delta), stddev(timing_delta), count(*) from myway_timingdeltas group by myway_stop having count(*) > 1 order by myway_stop";
$query = $conn->prepare($query);
$query->execute();
if (!$query) {
@@ -91,7 +90,7 @@
?>
Route |
1 order by route_full_name";
+ $query = "select route_name, avg(timing_delta), stddev(timing_delta), count(*) from myway_timingdeltas group by route_name having count(*) > 1 order by route_name";
$query = $conn->prepare($query);
$query->execute();
if (!$query) {