diff options
author | Daniel Friesel <derf@finalrewind.org> | 2015-02-24 16:42:35 +0100 |
---|---|---|
committer | Daniel Friesel <derf@finalrewind.org> | 2015-02-24 16:42:35 +0100 |
commit | 9205499fee8c80df7f6903d6e7772a68e401173b (patch) | |
tree | b1e2972494c5031ae64e7eb699d27969603c615c | |
parent | a37f5d3aee752de6ea5c25e6047efbe569f85d75 (diff) |
index: sort tsv metric cases
-rw-r--r-- | index.pl | 12 |
1 files changed, 6 insertions, 6 deletions
@@ -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, |