From 1a9100191d285dd299261355dfa39f2caf251f20 Mon Sep 17 00:00:00 2001 From: Daniel Friesel Date: Tue, 24 Mar 2015 22:32:20 +0100 Subject: globalstats: adjust for canceled trains --- index.pl | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/index.pl b/index.pl index 7f5d602..f6cf200 100644 --- a/index.pl +++ b/index.pl @@ -193,21 +193,21 @@ helper globalstats => sub { realtime_rate => $self->single_query( "select avg((delay is not null)::int) from departures"), ontime => $self->single_query( - "select count(*) from departures where delay < 1"), + "select count(*) from departures where delay < 1 and not is_canceled"), ontime_rate => - $self->single_query("select avg((delay < 1)::int) from departures"), + $self->single_query("select avg((delay < 1 and not is_canceled)::int) from departures"), days => $self->count_unique_column( '(scheduled_time at time zone \'GMT\')::date'), delayed => $self->single_query( - "select count(*) from departures where delay > 5"), + "select count(*) from departures where delay > 5 and not is_canceled"), delayed_rate => - $self->single_query("select avg((delay > 5)::int) from departures"), + $self->single_query("select avg((delay > 5 and not is_canceled)::int) from departures"), canceled => $self->single_query( "select count(*) from departures where is_canceled"), canceled_rate => $self->single_query("select avg(is_canceled::int) from departures"), - delay_sum => $self->single_query("select sum(delay) from departures"), - delay_avg => $self->single_query("select avg(delay) from departures"), + delay_sum => $self->single_query("select sum(delay) from departures where not is_canceled"), + delay_avg => $self->single_query("select avg(delay) from departures where not is_canceled"), }; return $ret; -- cgit v1.2.3