summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--index.pl2
1 files changed, 1 insertions, 1 deletions
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') {