This is an automated email from the ASF dual-hosted git repository.
lynwee pushed a commit to branch dev-1
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/dev-1 by this push:
new 1f61606a8 feat(dashboard): use incident tables in dora-detail:change
failure rate
1f61606a8 is described below
commit 1f61606a8c6946455464e4934b8ec7f38fa075f6
Author: d4x1 <[email protected]>
AuthorDate: Wed Jul 31 15:54:09 2024 +0800
feat(dashboard): use incident tables in dora-detail:change failure rate
---
grafana/dashboards/DORADetails-ChangeFailureRate.json | 14 +++++++-------
1 file changed, 7 insertions(+), 7 deletions(-)
diff --git a/grafana/dashboards/DORADetails-ChangeFailureRate.json
b/grafana/dashboards/DORADetails-ChangeFailureRate.json
index e9d165ce7..8fed04ffd 100644
--- a/grafana/dashboards/DORADetails-ChangeFailureRate.json
+++ b/grafana/dashboards/DORADetails-ChangeFailureRate.json
@@ -164,7 +164,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 3: change failure rate\nwith _deployments as
(\n-- When deploying multiple commits in one pipeline, GitLab and BitBucket may
generate more than one deployment. However, DevLake consider these deployments
as ONE production deployment and use the last one's finished_date as the
finished date.\n\tSELECT\n\t\tcdc.cicd_deployment_id as
deployment_id,\n\t\tmax(cdc.finished_date) as deployment_finished_date\n\tFROM
\n\t\tcicd_deployment_commits cdc\n\t\tJOIN proje [...]
+ "rawSql": "-- Metric 3: change failure rate\nwith _deployments as
(\n -- When deploying multiple commits in one pipeline, GitLab and BitBucket
may generate more than one deployment. However, DevLake consider these
deployments as ONE production deployment and use the last one's finished_date
as the finished date.\n SELECT\n cdc.cicd_deployment_id as deployment_id,\n
max(cdc.finished_date) as deployment_finished_date\n FROM\n
cicd_deployment_commits cdc\n JOIN proj [...]
"refId": "A",
"select": [
[
@@ -502,7 +502,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 3: change failure rate\nwith _deployments as
(\n-- When deploying multiple commits in one pipeline, GitLab and BitBucket may
generate more than one deployment. However, DevLake consider these deployments
as ONE production deployment and use the last one's finished_date as the
finished date.\n\tSELECT\n\t\tcdc.cicd_deployment_id as
deployment_id,\n\t\tmax(cdc.finished_date) as deployment_finished_date\n\tFROM
\n\t\tcicd_deployment_commits cdc\n\t\tJOIN proje [...]
+ "rawSql": "-- Metric 3: change failure rate\nwith _deployments as
(\n -- When deploying multiple commits in one pipeline, GitLab and BitBucket
may generate more than one deployment. However, DevLake consider these
deployments as ONE production deployment and use the last one's finished_date
as the finished date.\n SELECT\n cdc.cicd_deployment_id as deployment_id,\n
max(cdc.finished_date) as deployment_finished_date\n FROM\n
cicd_deployment_commits cdc\n JOIN proj [...]
"refId": "A",
"select": [
[
@@ -547,7 +547,7 @@
},
{
"datasource": "mysql",
- "description": "",
+ "description": "",
"fieldConfig": {
"defaults": {
"color": {
@@ -627,7 +627,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _deployments as(\n select distinct \n
d.cicd_deployment_id as deployment_id,\n d.result,\n
d.environment,\n d.finished_date,\n d.cicd_scope_id,\n
pm.project_name\n from \n cicd_deployment_commits d\n join
project_mapping pm on d.cicd_scope_id = pm.row_id and pm.`table` =
'cicd_scopes'\n where \n -- only result needs to specified, not
envioronment\n d.result = 'SUCCESS'\n -- cho [...]
+ "rawSql": "with _deployments as(\n select\n distinct
d.cicd_deployment_id as deployment_id,\n d.result,\n d.environment,\n
d.finished_date,\n d.cicd_scope_id,\n pm.project_name\n from\n
cicd_deployment_commits d\n join project_mapping pm on d.cicd_scope_id =
pm.row_id\n and pm.`table` = 'cicd_scopes'\n where\n -- only result
needs to specified, not envioronment\n d.result = 'SUCCESS' -- choose your
project_name\n and pm.project_name in ($p [...]
"refId": "A",
"select": [
[
@@ -687,7 +687,7 @@
"value": "$__all"
},
"datasource": "mysql",
- "definition": "select distinct name from projects",
+ "definition": "select distinct name from projects",
"hide": 0,
"includeAll": true,
"label": "Project",
@@ -708,7 +708,7 @@
"value": "2023"
},
"datasource": "mysql",
- "definition": "select dora_report from dora_benchmarks",
+ "definition": "select dora_report from dora_benchmarks",
"hide": 0,
"includeAll": false,
"label": "DORA Report",
@@ -729,7 +729,7 @@
"value": "Failed Deployment Recovery Time"
},
"datasource": "mysql",
- "definition": "SELECT \n CASE \n WHEN dora_report =
'2023' THEN \"Failed Deployment Recovery Time\"\n WHEN dora_report = '2021'
THEN \"Median Time to Restore Service\"\n ELSE NULL \n END AS
title_value\nFROM dora_benchmarks\nWHERE dora_report = '${dora_report:raw}'",
+ "definition": "SELECT \n CASE \n WHEN dora_report = '2023' THEN
\"Failed Deployment Recovery Time\"\n WHEN dora_report = '2021' THEN
\"Median Time to Restore Service\"\n ELSE NULL \n END AS title_value\nFROM
dora_benchmarks\nWHERE dora_report = '${dora_report:raw}'",
"hide": 2,
"includeAll": false,
"label": "TitleValue",
