19 lines
405 B
YAML
19 lines
405 B
YAML
- name: hits
|
|
label: Hits
|
|
chart: bar
|
|
query: |
|
|
SELECT {bucket} AS bucket,
|
|
COUNT(*) AS value
|
|
FROM logs
|
|
GROUP BY bucket
|
|
ORDER BY bucket
|
|
|
|
- name: error_rate
|
|
label: Error Rate (%)
|
|
chart: line
|
|
query: |
|
|
SELECT {bucket} AS bucket,
|
|
SUM(CASE WHEN status >= 500 THEN 1 ELSE 0 END) * 100.0 / COUNT(*) AS value
|
|
FROM logs
|
|
GROUP BY bucket
|
|
ORDER BY bucket
|