From 4d17f9167fa57d14576fe96f580123805cdf1100 Mon Sep 17 00:00:00 2001 From: Daniel Friesel Date: Wed, 25 Feb 2015 15:56:56 +0100 Subject: index: fix cancel_num --- index.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/index.pl b/index.pl index 5b18127..a76ce5b 100644 --- a/index.pl +++ b/index.pl @@ -150,7 +150,7 @@ get '/2ddata.tsv' => sub { when ('cancel_num') { $query = qq{ select $format as aggregate, - count(is_canceled) from $table where $where_clause group by aggregate + count() from $table where is_canceled > 0 and $where_clause group by aggregate }; } when ('cancel_rate') { -- cgit v1.2.3