summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Friesel <derf@finalrewind.org>2015-03-22 18:50:51 +0100
committerDaniel Friesel <derf@finalrewind.org>2015-03-22 18:50:51 +0100
commit9a18b68cfb580691ddd02a73e936c7cad4aa3d72 (patch)
treeca8129d70e1b32b9a79d4c7022f85f450d3473af
parent0b622572141e8c724e133685174a68cfe945e92c (diff)
index: fix stddev/count order in realtime-Rate
-rw-r--r--index.pl3
1 files changed, 2 insertions, 1 deletions
diff --git a/index.pl b/index.pl
index 9ff4ed9..6e3df19 100644
--- a/index.pl
+++ b/index.pl
@@ -424,8 +424,9 @@ get '/2ddata.tsv' => sub {
when ('realtime_rate') {
$query = qq{
select $format as aggregate, avg((delay is not null)::int),
+ count(*),
stddev_samp((delay is not null)::int),
- count(*), sum((delay is not null)::int)
+ sum((delay is not null)::int)
from departures
$join_clause
where $where_clause