From 9205499fee8c80df7f6903d6e7772a68e401173b Mon Sep 17 00:00:00 2001
From: Daniel Friesel <derf@finalrewind.org>
Date: Tue, 24 Feb 2015 16:42:35 +0100
Subject: index: sort tsv metric cases

---
 index.pl | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'index.pl')

diff --git a/index.pl b/index.pl
index 630442e..3eb83e3 100644
--- a/index.pl
+++ b/index.pl
@@ -86,12 +86,6 @@ get '/2ddata.tsv' => sub {
 	}
 
 	given ($metric) {
-		when ('delay') {
-			$query = qq{
-				select $format as aggregate,
-				avg(delay) from $table where not is_canceled and $where_clause group by aggregate
-			};
-		}
 		when ('cancel_num') {
 			$query = qq{
 				select $format as aggregate,
@@ -104,6 +98,12 @@ get '/2ddata.tsv' => sub {
 				avg(is_canceled) from $table where $where_clause group by aggregate
 			};
 		}
+		when ('delay') {
+			$query = qq{
+				select $format as aggregate,
+				avg(delay) from $table where not is_canceled and $where_clause group by aggregate
+			};
+		}
 		when ('message_rate') {
 			$query = qq{
 				select $format as aggregate,
-- 
cgit v1.2.3