diff options
-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, |