summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Friesel <derf@finalrewind.org>2015-02-24 16:42:35 +0100
committerDaniel Friesel <derf@finalrewind.org>2015-02-24 16:42:35 +0100
commit9205499fee8c80df7f6903d6e7772a68e401173b (patch)
treeb1e2972494c5031ae64e7eb699d27969603c615c
parenta37f5d3aee752de6ea5c25e6047efbe569f85d75 (diff)
index: sort tsv metric cases
-rw-r--r--index.pl12
1 files changed, 6 insertions, 6 deletions
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,