summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Friesel <derf@finalrewind.org>2015-02-25 15:56:56 +0100
committerDaniel Friesel <derf@finalrewind.org>2015-02-25 15:56:56 +0100
commit4d17f9167fa57d14576fe96f580123805cdf1100 (patch)
treef0a92790fd3e947bbc4af48c940b950359bf069e
parent7b1b16de6e87902d072fc33c87d29db93979bcb0 (diff)
index: fix cancel_num
-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') {