diff options
author | Daniel Friesel <derf@finalrewind.org> | 2015-02-23 10:47:44 +0100 |
---|---|---|
committer | Daniel Friesel <derf@finalrewind.org> | 2015-02-23 10:47:44 +0100 |
commit | 60365f7ee8b34a3d4c92fde708e5fa7110e0ce34 (patch) | |
tree | 2571bf2b308e8efe405fcb4d85db096ca464d0d1 /index.pl | |
parent | 5fb74f4f347453f44ab8f86fff0448218cf86d12 (diff) |
proper number formatting
Diffstat (limited to 'index.pl')
-rw-r--r-- | index.pl | 8 |
1 files changed, 4 insertions, 4 deletions
@@ -96,16 +96,16 @@ get '/2ddata.tsv' => sub { count(is_canceled) from $table where $where_clause group by aggregate }; } - when ('cancel_percent') { + when ('cancel_rate') { $query = qq{ select $format as aggregate, - avg(is_canceled) * 100 from $table where $where_clause group by aggregate + avg(is_canceled) from $table where $where_clause group by aggregate }; } - when ('message_percent') { + when ('message_rate') { $query = qq{ select $format as aggregate, - avg(msgtable.train_id is not null) * 100 from departures + avg(msgtable.train_id is not null) from departures left outer join msg_$msgnum as msgtable using (scheduled_time, train_id) where $where_clause group by aggregate }; |