This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a commit to branch release-v0.16
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/release-v0.16 by this push:
new c4a8706a6 fix: monthly cfr in DORA dashboard (#4974)
c4a8706a6 is described below
commit c4a8706a67e13e3ca3f3a47236d6db5513ec9861
Author: Louis.z <[email protected]>
AuthorDate: Thu Apr 20 09:52:17 2023 +0800
fix: monthly cfr in DORA dashboard (#4974)
Co-authored-by: Startrekzky <[email protected]>
---
grafana/dashboards/DORA.json | 18 ++++++++----------
1 file changed, 8 insertions(+), 10 deletions(-)
diff --git a/grafana/dashboards/DORA.json b/grafana/dashboards/DORA.json
index e1309fef8..ab0cf6730 100644
--- a/grafana/dashboards/DORA.json
+++ b/grafana/dashboards/DORA.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 28,
- "iteration": 1681113037519,
+ "id": 12,
+ "iteration": 1681911584843,
"links": [],
"panels": [
{
@@ -143,7 +143,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 1: Deployment Frequency\nwith
last_few_calendar_months as(\n-- get the last few months within the selected
time period in the top-right corner\n\tSELECT CAST((SYSDATE()-INTERVAL (H+T+U)
DAY) AS date) day\n\tFROM ( SELECT 0 H\n\t\t\tUNION ALL SELECT 100 UNION ALL
SELECT 200 UNION ALL SELECT 300\n\t\t) H CROSS JOIN ( SELECT 0 T\n\t\t\tUNION
ALL SELECT 10 UNION ALL SELECT 20 UNION ALL SELECT 30\n\t\t\tUNION ALL
SELECT 40 UNION ALL SELECT 50 UNION ALL SELE [...]
+ "rawSql": "-- Metric 1: Deployment Frequency\nwith
last_few_calendar_months as(\n-- get the last few months within the selected
time period in the top-right corner\n\tSELECT CAST((SYSDATE()-INTERVAL (H+T+U)
DAY) AS date) day\n\tFROM ( SELECT 0 H\n\t\t\tUNION ALL SELECT 100 UNION ALL
SELECT 200 UNION ALL SELECT 300\n\t\t) H CROSS JOIN ( SELECT 0 T\n\t\t\tUNION
ALL SELECT 10 UNION ALL SELECT 20 UNION ALL SELECT 30\n\t\t\tUNION ALL
SELECT 40 UNION ALL SELECT 50 UNION ALL SELE [...]
"refId": "A",
"select": [
[
@@ -543,7 +543,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 4: change failure rate\nwith _deployments as
(\n-- get the deployment deployed within the selected time period in the
top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date
as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin
project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t
pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result =
'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...]
+ "rawSql": "-- Metric 4: change failure rate\nwith _deployments as
(\n-- get the deployment deployed within the selected time period in the
top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date
as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin
project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t
pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result =
'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...]
"refId": "A",
"select": [
[
@@ -797,7 +797,7 @@
{
"matcher": {
"id": "byName",
- "options": "med_time_to_resolve_in_hour"
+ "options": "median_time_to_resolve_in_hour"
},
"properties": [
{
@@ -940,9 +940,7 @@
},
"orientation": "auto",
"showValue": "auto",
- "text": {
- "valueSize": 1
- },
+ "text": {},
"tooltip": {
"mode": "single"
}
@@ -955,7 +953,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "with _deployments as (\n-- get the deployments in each
month\n\tSELECT\n\t date_format(ct.finished_date,'%y/%m') as month,\n\t\tct.id
AS deployment_id\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin project_mapping pm on
ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t pm.project_name in
($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result = 'SUCCESS'\n\t\tand
environment = 'PRODUCTION'\n),\n\n_incidents as (\n-- get the incidents (caused
by deployments) that are created within t [...]
+ "rawSql": "-- Metric 4: change failure rate\nwith _deployments as
(\n-- get the deployment deployed within the selected time period in the
top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date
as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin
project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t
pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result =
'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...]
"refId": "A",
"select": [
[
@@ -1029,5 +1027,5 @@
"timezone": "",
"title": "DORA",
"uid": "qNo8_0M4z",
- "version": 5
+ "version": 2
}
\ No newline at end of file
