You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by ab...@apache.org on 2024/08/27 07:11:58 UTC
(incubator-devlake) branch main updated: fix: polish DORA dashboards (#7961)
This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/main by this push:
new 11c21ab96 fix: polish DORA dashboards (#7961)
11c21ab96 is described below
commit 11c21ab96f1d02849bdf13e739dc95d366581051
Author: Louis.z <lo...@gmail.com>
AuthorDate: Tue Aug 27 15:11:53 2024 +0800
fix: polish DORA dashboards (#7961)
Co-authored-by: Startrekzky <ka...@merico.dev>
---
grafana/dashboards/DORA.json | 72 ++++---
grafana/dashboards/DORAByTeam.json | 70 ++++---
grafana/dashboards/DORADebug.json | 229 +++++++++------------
.../DORADetails-DeploymentFrequency.json | 23 ++-
.../DORADetails-FailedDeploymentRecoveryTime.json | 28 +--
5 files changed, 208 insertions(+), 214 deletions(-)
diff --git a/grafana/dashboards/DORA.json b/grafana/dashboards/DORA.json
index 79c2a1959..85ea67ac3 100644
--- a/grafana/dashboards/DORA.json
+++ b/grafana/dashboards/DORA.json
@@ -18,7 +18,7 @@
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 39,
+ "id": 41,
"links": [],
"liveNow": false,
"panels": [
@@ -34,7 +34,6 @@
"y": 0
},
"id": 16,
- "links": [],
"options": {
"code": {
"language": "plaintext",
@@ -44,7 +43,7 @@
"content": "- See [how to config](https://devlake.apache.org/docs/DORA) this dashboard\n- Data Sources Required: \n - `Deployments` from Jenkins, GitLab CI, GitHub Action, webhook, etc. \n - `Pull Requests` from GitHub PRs, GitLab MRs, BitBucket PRs, Azure DevOps PRs, etc.\n - `Incidents` from Jira issues, GitHub issues, TAPD issues, PagerDuty Incidents, etc. \n- Transformation Required: Define `deployments` and `incidents` in [data transformations](https://devlake.apache.org/ [...]
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -211,7 +210,6 @@
"y": 7
},
"id": 8,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -225,7 +223,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -235,7 +233,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n -- construct the last few calendar months within the selected time period in the top-right corner\n SELECT\n CAST(($__timeTo() - INTERVAL (H + T + U) DAY) AS date) day\n FROM\n (\n SELECT\n 0 H\n UNION\n ALL\n SELECT\n 100\n UNION\n ALL\n SELECT\n 200\n UNION\n ALL\n SELECT\n 300\n ) H\n CROSS JOIN (\n [...]
+ "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n -- construct the last few calendar months within the selected time period in the top-right corner\n SELECT\n CAST(($__timeTo() - INTERVAL (H + T + U) DAY) AS date) day\n FROM\n (\n SELECT\n 0 H\n UNION\n ALL\n SELECT\n 100\n UNION\n ALL\n SELECT\n 200\n UNION\n ALL\n SELECT\n 300\n ) H\n CROSS JOIN (\n [...]
"refId": "A",
"select": [
[
@@ -333,7 +331,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
}
]
@@ -367,10 +365,12 @@
"fields": "/^Deployment Frequency$/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -380,7 +380,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n-- construct the last few calendar months within the selected time period in the top-right corner\n\tSELECT CAST(($__timeTo()-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 [...]
+ "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n-- construct the last few calendar months within the selected time period in the top-right corner\n\tSELECT CAST(($__timeTo()-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 [...]
"refId": "A",
"select": [
[
@@ -478,7 +478,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
}
]
@@ -511,10 +511,12 @@
"fields": "/.*/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -622,7 +624,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
}
]
@@ -656,10 +658,12 @@
"fields": "/^change_failure_rate$/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -669,7 +673,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 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 [...]
+ "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": [
[
@@ -767,7 +771,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
},
{
@@ -808,10 +812,12 @@
"fields": "/.*/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -821,7 +827,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- ***** 2023 report ***** --\n-- Metric 4: Failed deployment recovery time\nwith _deployments as (\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 project_mapping pm on cdc.cicd_scope_id = pm.row_id\n and pm.`table` = 'cicd_scopes'\n WHERE\n pm.project_name in ($project)\n and cdc.result = 'SUCCESS'\n and cdc.environment = 'PRODUCTION'\n [...]
+ "rawSql": "-- ***** 2023 report ***** --\n-- Metric 4: Failed deployment recovery time\nwith _deployments as (\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 project_mapping pm on cdc.cicd_scope_id = pm.row_id\n and pm.`table` = 'cicd_scopes'\n WHERE\n pm.project_name in ($project)\n and cdc.result = 'SUCCESS'\n and cdc.environment = 'PRODUCTION'\n [...]
"refId": "A",
"select": [
[
@@ -873,6 +879,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
@@ -939,6 +946,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -1007,6 +1015,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Hours",
@@ -1069,6 +1078,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -1138,6 +1148,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
@@ -1221,6 +1232,7 @@
"valueSize": 12
},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -1290,6 +1302,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Hours",
@@ -1377,6 +1390,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -1439,8 +1453,7 @@
}
],
"refresh": "",
- "schemaVersion": 38,
- "style": "dark",
+ "schemaVersion": 39,
"tags": [
"Engineering Leads Dashboard",
"Highlights",
@@ -1450,7 +1463,7 @@
"list": [
{
"current": {
- "selected": false,
+ "selected": true,
"text": [
"All"
],
@@ -1475,9 +1488,9 @@
},
{
"current": {
- "selected": true,
- "text": "2021",
- "value": "2021"
+ "selected": false,
+ "text": "2023",
+ "value": "2023"
},
"datasource": "mysql",
"definition": "select dora_report from dora_benchmarks",
@@ -1497,8 +1510,8 @@
{
"current": {
"selected": false,
- "text": "Median Time to Restore Service",
- "value": "Median Time to Restore Service"
+ "text": "Failed Deployment Recovery Time",
+ "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}'",
@@ -1521,6 +1534,7 @@
"from": "now-6M",
"to": "now"
},
+ "timeRangeUpdatedDuringEditOrView": false,
"timepicker": {},
"timezone": "utc",
"title": "DORA",
diff --git a/grafana/dashboards/DORAByTeam.json b/grafana/dashboards/DORAByTeam.json
index b755996cc..972d11ee2 100644
--- a/grafana/dashboards/DORAByTeam.json
+++ b/grafana/dashboards/DORAByTeam.json
@@ -24,7 +24,7 @@
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 45,
+ "id": 43,
"links": [],
"liveNow": false,
"panels": [
@@ -40,7 +40,6 @@
"y": 0
},
"id": 16,
- "links": [],
"options": {
"code": {
"language": "plaintext",
@@ -50,7 +49,7 @@
"content": "- See [how to config](https://devlake.apache.org/docs/DORA) this dashboard\n- Data Sources Required: \n - `Deployments` from Jenkins, GitLab CI, GitHub Action, webhook, etc. \n - `Pull Requests` from GitHub PRs, GitLab MRs, BitBucket PRs, Azure DevOps PRs, etc.\n - `Incidents` from Jira issues, GitHub issues, TAPD issues, PagerDuty Incidents, etc. \n- Transformation Required: Define `deployments` and `incidents` in [data transformations](https://devlake.apache.org/ [...]
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -186,7 +185,6 @@
"y": 10
},
"id": 8,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -200,7 +198,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -208,7 +206,7 @@
"format": "table",
"hide": false,
"rawQuery": true,
- "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n -- construct the last few calendar months within the selected time period in the top-right corner\n SELECT\n CAST(($__timeTo() - INTERVAL (H + T + U) DAY) AS date) day\n FROM\n (\n SELECT\n 0 H\n UNION\n ALL\n SELECT\n 100\n UNION\n ALL\n SELECT\n 200\n UNION\n ALL\n SELECT\n 300\n ) H\n CROSS JOIN (\n [...]
+ "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n -- construct the last few calendar months within the selected time period in the top-right corner\n SELECT\n CAST(($__timeTo() - INTERVAL (H + T + U) DAY) AS date) day\n FROM\n (\n SELECT\n 0 H\n UNION\n ALL\n SELECT\n 100\n UNION\n ALL\n SELECT\n 200\n UNION\n ALL\n SELECT\n 300\n ) H\n CROSS JOIN (\n [...]
"refId": "A",
"sql": {
"columns": [
@@ -285,7 +283,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
}
]
@@ -300,7 +298,6 @@
"y": 16
},
"id": 11,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -313,10 +310,12 @@
"fields": "/^Deployment Frequency$/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -326,7 +325,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n-- construct the last few calendar months within the selected time period in the top-right corner\n\tSELECT CAST(($__timeTo()-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 [...]
+ "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n-- construct the last few calendar months within the selected time period in the top-right corner\n\tSELECT CAST(($__timeTo()-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 [...]
"refId": "A",
"select": [
[
@@ -423,7 +422,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
}
]
@@ -438,7 +437,6 @@
"y": 16
},
"id": 12,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -451,10 +449,12 @@
"fields": "/^median_change_lead_time$/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -539,7 +539,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
}
]
@@ -554,7 +554,6 @@
"y": 16
},
"id": 14,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -567,10 +566,12 @@
"fields": "/^change_failure_rate$/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -656,12 +657,8 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
- },
- {
- "color": "red",
- "value": 80
}
]
}
@@ -675,7 +672,6 @@
"y": 16
},
"id": 13,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -688,10 +684,12 @@
"fields": "/^median_time_in_hour$/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -699,7 +697,7 @@
"format": "table",
"hide": false,
"rawQuery": true,
- "rawSql": "-- ***** 2023 report ***** --\n-- Metric 4: Failed deployment recovery time\nwith _deployments as (\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\t\tJOIN commits c on cdc.commit_sha = c.sha\n join user_accounts ua on c.author_id = ua.account_id\n join users u on ua.user_id = u.id\n join team_users tu on u.id = tu.user_id [...]
+ "rawSql": "-- ***** 2023 report ***** --\n-- Metric 4: Failed deployment recovery time\nwith _deployments as (\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\t\tJOIN commits c on cdc.commit_sha = c.sha\n join user_accounts ua on c.author_id = ua.account_id\n join users u on ua.user_id = u.id\n join team_users tu on u.id = tu.user_id [...]
"refId": "A",
"sql": {
"columns": [
@@ -731,6 +729,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
@@ -775,7 +774,6 @@
"y": 21
},
"id": 2,
- "links": [],
"options": {
"barRadius": 0,
"barWidth": 0.6,
@@ -792,6 +790,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -838,6 +837,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Hours",
@@ -878,7 +878,6 @@
"y": 21
},
"id": 6,
- "links": [],
"options": {
"barRadius": 0,
"barWidth": 0.7,
@@ -895,6 +894,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -942,6 +942,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
@@ -1001,7 +1002,6 @@
"y": 29
},
"id": 5,
- "links": [],
"options": {
"barRadius": 0,
"barWidth": 0.6,
@@ -1018,6 +1018,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -1065,6 +1066,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Hours",
@@ -1110,7 +1112,6 @@
"y": 29
},
"id": 9,
- "links": [],
"options": {
"barRadius": 0,
"barWidth": 0.6,
@@ -1127,6 +1128,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -1167,8 +1169,7 @@
}
],
"refresh": "",
- "schemaVersion": 38,
- "style": "dark",
+ "schemaVersion": 39,
"tags": [
"Engineering Leads Dashboard"
],
@@ -1243,6 +1244,7 @@
"from": "now-6M",
"to": "now"
},
+ "timeRangeUpdatedDuringEditOrView": false,
"timepicker": {},
"timezone": "utc",
"title": "DORA (by Team)",
diff --git a/grafana/dashboards/DORADebug.json b/grafana/dashboards/DORADebug.json
index df4579f54..f547740bb 100644
--- a/grafana/dashboards/DORADebug.json
+++ b/grafana/dashboards/DORADebug.json
@@ -18,7 +18,7 @@
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 26,
+ "id": 44,
"links": [],
"liveNow": false,
"panels": [
@@ -34,7 +34,6 @@
"y": 0
},
"id": 63,
- "links": [],
"options": {
"code": {
"language": "plaintext",
@@ -44,7 +43,7 @@
"content": "This dashboard is designed to validate the [DORA dashboard](/grafana/d/qNo8_0M4z/dora?orgId=1).",
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -105,7 +104,7 @@
"content": "- See the definition and calculation logic of [Deployment Frequency](https://devlake.apache.org/docs/Metrics/DeploymentFrequency)\n- Data Sources Required: \n - `Deployments` from Jenkins, GitLab CI, GitHub Action, BitBucket Pipelines, or Webhook, etc. \n- Transformation Required: Define `deployments` in [data transformations](https://devlake.apache.org/docs/Configuration/Tutorial#step-3---add-transformations-optional) while configuring the blueprint of a project.",
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -177,7 +176,6 @@
"y": 6
},
"id": 16,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -191,7 +189,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -280,7 +278,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
+ "color": "text",
"value": null
}
]
@@ -295,7 +293,6 @@
"y": 6
},
"id": 15,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -308,10 +305,12 @@
"fields": "/^Deployment Frequency$/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -321,7 +320,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n-- construct the last few calendar months within the selected time period in the top-right corner\n\tSELECT CAST(($__timeTo()-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 [...]
+ "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n-- construct the last few calendar months within the selected time period in the top-right corner\n\tSELECT CAST(($__timeTo()-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 [...]
"refId": "A",
"select": [
[
@@ -424,7 +423,6 @@
"y": 11
},
"id": 29,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -438,7 +436,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -482,6 +480,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
@@ -526,7 +525,6 @@
"y": 15
},
"id": 34,
- "links": [],
"options": {
"barRadius": 0,
"barWidth": 0.6,
@@ -543,6 +541,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -669,7 +668,6 @@
"y": 16
},
"id": 49,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -683,7 +681,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -787,7 +785,6 @@
"y": 21
},
"id": 11,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -801,7 +798,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -905,7 +902,6 @@
"y": 21
},
"id": 50,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -919,7 +915,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1002,7 +998,7 @@
"content": "- See the definition and calculation logic of [Median Lead Time for Changes](https://devlake.apache.org/docs/Metrics/LeadTimeForChanges)\n- Data Sources Required: \n - `Deployments` from Jenkins, GitLab CI, GitHub Action, BitBucket Pipelines, or Webhook, etc. \n - `Pull Requests` from GitHub PRs, GitLab MRs, BitBucket PRs, Azure DevOps PRs, etc.\n- Transformation Required: Define `deployments` in [data transformations](https://devlake.apache.org/docs/Configuration/T [...]
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -1037,8 +1033,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -1052,7 +1047,6 @@
"y": 34
},
"id": 18,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -1065,7 +1059,7 @@
},
"showHeader": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1154,8 +1148,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "text"
}
]
}
@@ -1169,7 +1162,6 @@
"y": 34
},
"id": 40,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -1182,10 +1174,12 @@
"fields": "/^median_change_lead_time$/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1271,8 +1265,7 @@
"mode": "absolute",
"steps": [
{
- "color": "red",
- "value": null
+ "color": "red"
}
]
}
@@ -1308,8 +1301,7 @@
"mode": "absolute",
"steps": [
{
- "color": "red",
- "value": null
+ "color": "red"
},
{
"color": "green",
@@ -1344,7 +1336,6 @@
"y": 39
},
"id": 53,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -1357,7 +1348,7 @@
},
"showHeader": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1402,6 +1393,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Hours",
@@ -1427,8 +1419,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -1442,7 +1433,6 @@
"y": 40
},
"id": 38,
- "links": [],
"options": {
"barRadius": 0,
"barWidth": 0.7,
@@ -1459,6 +1449,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -1544,8 +1535,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -1559,8 +1549,9 @@
"y": 42
},
"id": 12,
- "links": [],
"options": {
+ "minVizHeight": 75,
+ "minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
@@ -1571,9 +1562,10 @@
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
+ "sizing": "auto",
"text": {}
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1683,8 +1675,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -1698,7 +1689,6 @@
"y": 46
},
"id": 68,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -1712,7 +1702,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1780,8 +1770,7 @@
"mode": "absolute",
"steps": [
{
- "color": "red",
- "value": null
+ "color": "red"
}
]
}
@@ -1809,8 +1798,7 @@
"mode": "absolute",
"steps": [
{
- "color": "red",
- "value": null
+ "color": "red"
},
{
"color": "green",
@@ -1859,7 +1847,6 @@
"y": 47
},
"id": 51,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -1872,7 +1859,7 @@
},
"showHeader": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1944,8 +1931,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -1959,7 +1945,6 @@
"y": 50
},
"id": 69,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -1973,7 +1958,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2021,8 +2006,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
},
{
"color": "red",
@@ -2040,8 +2024,9 @@
"y": 54
},
"id": 52,
- "links": [],
"options": {
+ "minVizHeight": 75,
+ "minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
@@ -2052,9 +2037,10 @@
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
+ "sizing": "auto",
"text": {}
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2132,8 +2118,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -2147,8 +2132,9 @@
"y": 54
},
"id": 54,
- "links": [],
"options": {
+ "minVizHeight": 75,
+ "minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
@@ -2159,9 +2145,10 @@
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
+ "sizing": "auto",
"text": {}
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2239,8 +2226,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -2254,8 +2240,9 @@
"y": 58
},
"id": 55,
- "links": [],
"options": {
+ "minVizHeight": 75,
+ "minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
@@ -2266,9 +2253,10 @@
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
+ "sizing": "auto",
"text": {}
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2346,8 +2334,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -2361,8 +2348,9 @@
"y": 58
},
"id": 56,
- "links": [],
"options": {
+ "minVizHeight": 75,
+ "minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
@@ -2373,9 +2361,10 @@
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
+ "sizing": "auto",
"text": {}
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2453,8 +2442,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -2468,8 +2456,9 @@
"y": 62
},
"id": 57,
- "links": [],
"options": {
+ "minVizHeight": 75,
+ "minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
@@ -2480,9 +2469,10 @@
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
+ "sizing": "auto",
"text": {}
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2538,8 +2528,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -2607,7 +2596,6 @@
"y": 66
},
"id": 70,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -2620,7 +2608,7 @@
},
"showHeader": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2703,7 +2691,7 @@
"content": "- See the definition and calculation logic of [${title_value}](https://devlake.apache.org/docs/Metrics/MTTR)\n- Data Sources Required: \n - `Deployments` from Jenkins, GitLab CI, GitHub Action, BitBucket Pipelines, or Webhook, etc. \n - `Incidents` from Jira issues, GitHub issues, TAPD issues, PagerDuty Incidents, etc. \n- Transformation Required: Define `deployments` and `incidents` in [data transformations](https://devlake.apache.org/docs/Configuration/Tutorial#st [...]
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -2737,7 +2725,7 @@
"content": "- See the definition and calculation logic of [Change Failure Rate](https://devlake.apache.org/docs/Metrics/CFR)\n- Data Sources Required: \n - `Deployments` from Jenkins, GitLab CI, GitHub Action, BitBucket Pipelines, or Webhook, etc. \n - `Incidents` from Jira issues, GitHub issues, TAPD issues, PagerDuty Incidents, etc. \n- Transformation Required: Define `deployments` and `incidents` in [data transformations](https://devlake.apache.org/docs/Configuration/Tutoria [...]
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -2785,8 +2773,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -2800,7 +2787,6 @@
"y": 83
},
"id": 31,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -2814,7 +2800,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2903,12 +2889,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
- },
- {
- "color": "red",
- "value": 80
+ "color": "text"
}
]
}
@@ -2922,7 +2903,6 @@
"y": 83
},
"id": 42,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -2935,10 +2915,12 @@
"fields": "/.*/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -2948,7 +2930,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- ***** 2023 report ***** --\n-- Metric 4: Failed deployment recovery time\nwith _deployments as (\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 project_mapping pm on cdc.cicd_scope_id = pm.row_id\n and pm.`table` = 'cicd_scopes'\n WHERE\n pm.project_name in ($project)\n and cdc.result = 'SUCCESS'\n and cdc.environment = 'PRODUCTION'\n [...]
+ "rawSql": "-- ***** 2023 report ***** --\n-- Metric 4: Failed deployment recovery time\nwith _deployments as (\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 project_mapping pm on cdc.cicd_scope_id = pm.row_id\n and pm.`table` = 'cicd_scopes'\n WHERE\n pm.project_name in ($project)\n and cdc.result = 'SUCCESS'\n and cdc.environment = 'PRODUCTION'\n [...]
"refId": "A",
"select": [
[
@@ -3027,8 +3009,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -3042,7 +3023,6 @@
"y": 89
},
"id": 14,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -3056,7 +3036,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -3104,7 +3084,6 @@
"y": 93
},
"id": 61,
- "links": [],
"options": {
"code": {
"language": "plaintext",
@@ -3114,7 +3093,7 @@
"content": "<img src = 'https://devlake.apache.org/assets/images/cfr-definition-94d92cc75f857f183443ad5390d31d65.png' />\n\nIn this case:\n\n- Deployment-1 maps to Incident-1\n- Deployment-3 maps to Incident-2 and Incident-3\n- Deployment-2,4,5 doesn't map to any Incident",
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -3137,6 +3116,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Hours",
@@ -3162,8 +3142,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
},
{
"color": "red",
@@ -3198,7 +3177,6 @@
"y": 93
},
"id": 46,
- "links": [],
"options": {
"barRadius": 0,
"barWidth": 0.6,
@@ -3215,6 +3193,7 @@
"stacking": "none",
"text": {},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -3328,8 +3307,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "text"
}
]
}
@@ -3343,7 +3321,6 @@
"y": 103
},
"id": 44,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -3356,10 +3333,12 @@
"fields": "/.*/",
"values": false
},
+ "showPercentChange": false,
"text": {},
- "textMode": "auto"
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -3449,8 +3428,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -3464,7 +3442,6 @@
"y": 108
},
"id": 58,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -3478,7 +3455,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -3550,8 +3527,7 @@
"mode": "absolute",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
}
@@ -3565,7 +3541,6 @@
"y": 108
},
"id": 59,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -3579,7 +3554,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -3642,6 +3617,7 @@
"mode": "palette-classic"
},
"custom": {
+ "axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
@@ -3669,8 +3645,7 @@
"mode": "percentage",
"steps": [
{
- "color": "green",
- "value": null
+ "color": "green"
}
]
},
@@ -3701,7 +3676,6 @@
"y": 111
},
"id": 48,
- "links": [],
"options": {
"barRadius": 0,
"barWidth": 0.6,
@@ -3720,6 +3694,7 @@
"valueSize": 12
},
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -3782,8 +3757,7 @@
}
],
"refresh": "",
- "schemaVersion": 38,
- "style": "dark",
+ "schemaVersion": 39,
"tags": [
"Engineering Leads Dashboard"
],
@@ -3813,8 +3787,8 @@
{
"current": {
"selected": false,
- "text": "https://github.com/apache/incubator-devlake/pull/5913",
- "value": "github:GithubPullRequest:1:1480194863"
+ "text": "",
+ "value": ""
},
"datasource": "mysql",
"definition": "select concat(Url, '--', id) from pull_requests",
@@ -3833,7 +3807,7 @@
},
{
"current": {
- "selected": true,
+ "selected": false,
"text": "2023",
"value": "2023"
},
@@ -3879,6 +3853,7 @@
"from": "now-6M",
"to": "now"
},
+ "timeRangeUpdatedDuringEditOrView": false,
"timepicker": {},
"timezone": "utc",
"title": "DORA Validation",
diff --git a/grafana/dashboards/DORADetails-DeploymentFrequency.json b/grafana/dashboards/DORADetails-DeploymentFrequency.json
index 9ff4541e7..44c49c5ad 100644
--- a/grafana/dashboards/DORADetails-DeploymentFrequency.json
+++ b/grafana/dashboards/DORADetails-DeploymentFrequency.json
@@ -18,7 +18,7 @@
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 7,
+ "id": 42,
"links": [
{
"asDropdown": false,
@@ -56,7 +56,7 @@
"content": "This dashboard shows the details about [deployment frequency](https://devlake.apache.org/docs/Metrics/DeploymentFrequency) in DORA.",
"mode": "markdown"
},
- "pluginVersion": "10.4.1",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -247,7 +247,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "10.4.1",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -365,7 +365,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "10.4.1",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -486,6 +486,7 @@
"showValue": "auto",
"stacking": "none",
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -614,6 +615,7 @@
"showValue": "auto",
"stacking": "none",
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -743,6 +745,7 @@
"showValue": "auto",
"stacking": "none",
"tooltip": {
+ "maxHeight": 600,
"mode": "single",
"sort": "none"
},
@@ -821,10 +824,10 @@
"showLineNumbers": false,
"showMiniMap": false
},
- "content": "# 2023 Benchmarks\n- Elite: >= 7 days per week\n- High: >= 1 day per week\n- Medium: >= 1 day per month\n- Low: < 1 day per month\n# 2021 Benchmarks\n- Elite: >= 7 days per week\n- High: >= 1 day per month\n- Medium: >= 1 day per six months\n- Low: < 1 day per six months",
+ "content": "# 2023 Benchmarks\n- Elite: >= 5 days per week\n- High: >= 1 day per week\n- Medium: >= 1 day per month\n- Low: < 1 day per month\n# 2021 Benchmarks\n- Elite: >= 5 days per week\n- High: >= 1 day per month\n- Medium: >= 1 day per six months\n- Low: < 1 day per six months",
"mode": "markdown"
},
- "pluginVersion": "10.4.1",
+ "pluginVersion": "11.0.0",
"title": "DORA Report",
"type": "text"
},
@@ -912,7 +915,7 @@
"textMode": "auto",
"wideLayout": true
},
- "pluginVersion": "10.4.1",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1050,7 +1053,7 @@
"textMode": "auto",
"wideLayout": true
},
- "pluginVersion": "10.4.1",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1188,7 +1191,7 @@
"textMode": "auto",
"wideLayout": true
},
- "pluginVersion": "10.4.1",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -1243,7 +1246,6 @@
"type": "stat"
}
],
- "refresh": "",
"schemaVersion": 39,
"tags": [
"DORA"
@@ -1323,6 +1325,7 @@
"from": "now-6M",
"to": "now"
},
+ "timeRangeUpdatedDuringEditOrView": false,
"timepicker": {},
"timezone": "utc",
"title": "DORA Details - Deployment Frequency",
diff --git a/grafana/dashboards/DORADetails-FailedDeploymentRecoveryTime.json b/grafana/dashboards/DORADetails-FailedDeploymentRecoveryTime.json
index 834605dad..4dfd6fb06 100644
--- a/grafana/dashboards/DORADetails-FailedDeploymentRecoveryTime.json
+++ b/grafana/dashboards/DORADetails-FailedDeploymentRecoveryTime.json
@@ -18,7 +18,7 @@
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 17,
+ "id": 45,
"links": [
{
"asDropdown": false,
@@ -47,7 +47,6 @@
"y": 0
},
"id": 63,
- "links": [],
"options": {
"code": {
"language": "plaintext",
@@ -57,7 +56,7 @@
"content": "This dashboard shows the details about [Failed Deployment Recovery Time\n](https://devlake.apache.org/docs/Metrics/MTTR) in DORA.",
"mode": "markdown"
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": {
@@ -98,7 +97,6 @@
"y": 2
},
"id": 87,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -111,9 +109,11 @@
"fields": "/.*/",
"values": false
},
- "textMode": "auto"
+ "showPercentChange": false,
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -121,7 +121,7 @@
"format": "table",
"hide": false,
"rawQuery": true,
- "rawSql": "-- ***** 2023 report ***** --\n-- Metric 4: Failed deployment recovery time\nwith _deployments as (\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 project_mapping pm on cdc.cicd_scope_id = pm.row_id\n and pm.`table` = 'cicd_scopes'\n WHERE\n pm.project_name in ($project)\n and cdc.result = 'SUCCESS'\n and cdc.environment = 'PRODUCTION'\n [...]
+ "rawSql": "-- ***** 2023 report ***** --\n-- Metric 4: Failed deployment recovery time\nwith _deployments as (\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 project_mapping pm on cdc.cicd_scope_id = pm.row_id\n and pm.`table` = 'cicd_scopes'\n WHERE\n pm.project_name in ($project)\n and cdc.result = 'SUCCESS'\n and cdc.environment = 'PRODUCTION'\n [...]
"refId": "D",
"sql": {
"columns": [
@@ -283,7 +283,6 @@
"y": 2
},
"id": 80,
- "links": [],
"options": {
"cellHeight": "sm",
"footer": {
@@ -305,7 +304,7 @@
}
]
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -386,7 +385,6 @@
"y": 12
},
"id": 88,
- "links": [],
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -399,9 +397,11 @@
"fields": "/.*/",
"values": false
},
- "textMode": "auto"
+ "showPercentChange": false,
+ "textMode": "auto",
+ "wideLayout": true
},
- "pluginVersion": "9.5.15",
+ "pluginVersion": "11.0.0",
"targets": [
{
"datasource": "mysql",
@@ -435,8 +435,7 @@
}
],
"refresh": "",
- "schemaVersion": 38,
- "style": "dark",
+ "schemaVersion": 39,
"tags": [
"DORA"
],
@@ -469,6 +468,7 @@
"from": "now-6M",
"to": "now"
},
+ "timeRangeUpdatedDuringEditOrView": false,
"timepicker": {},
"timezone": "utc",
"title": "DORA Details - Failed Deployment Recovery Time",