summaryrefslogtreecommitdiff
path: root/index.pl
diff options
context:
space:
mode:
authorDaniel Friesel <derf@finalrewind.org>2015-02-23 10:47:44 +0100
committerDaniel Friesel <derf@finalrewind.org>2015-02-23 10:47:44 +0100
commit60365f7ee8b34a3d4c92fde708e5fa7110e0ce34 (patch)
tree2571bf2b308e8efe405fcb4d85db096ca464d0d1 /index.pl
parent5fb74f4f347453f44ab8f86fff0448218cf86d12 (diff)
proper number formatting
Diffstat (limited to 'index.pl')
-rw-r--r--index.pl8
1 files changed, 4 insertions, 4 deletions
diff --git a/index.pl b/index.pl
index ff1cf65..2188c21 100644
--- a/index.pl
+++ b/index.pl
@@ -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
};