From dbba459cee5a27d4aaf32c2e989c3604913000be Mon Sep 17 00:00:00 2001
From: Daniel Friesel <derf@finalrewind.org>
Date: Tue, 3 Mar 2015 18:30:07 +0100
Subject: barplot: Handle NULL values in delay/is_canceled in count

---
 index.pl | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/index.pl b/index.pl
index c29c314..51b524c 100644
--- a/index.pl
+++ b/index.pl
@@ -215,7 +215,7 @@ get '/2ddata.tsv' => sub {
 	given ($metric) {
 		when ('avg_delay') {
 			$query = qq{
-				select $format as aggregate, avg(delay), count()
+				select $format as aggregate, avg(delay), count(delay)
 				from $table where not is_canceled and $where_clause group by aggregate
 			};
 		}
@@ -227,21 +227,21 @@ get '/2ddata.tsv' => sub {
 		}
 		when ('cancel_rate') {
 			$query = qq{
-				select $format as aggregate, avg(is_canceled), count(),
+				select $format as aggregate, avg(is_canceled), count(is_canceled),
 					sum(is_canceled = 1)
 				from $table where $where_clause group by aggregate
 			};
 		}
 		when ('delay0_rate') {
 			$query = qq{
-				select $format as aggregate, avg(delay < 1), count(),
+				select $format as aggregate, avg(delay < 1), count(delay),
 					sum(delay < 1)
 				from $table where $where_clause group by aggregate
 			};
 		}
 		when ('delay5_rate') {
 			$query = qq{
-				select $format as aggregate, avg(delay > 5), count(),
+				select $format as aggregate, avg(delay > 5), count(delay),
 					sum(delay > 5)
 				from $table where $where_clause group by aggregate
 			};
-- 
cgit v1.2.3