You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by zk...@apache.org on 2022/10/13 02:03:10 UTC
[incubator-devlake] branch release-v0.14 updated: fix: update change lead time (#3410)
This is an automated email from the ASF dual-hosted git repository.
zky pushed a commit to branch release-v0.14
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/release-v0.14 by this push:
new 8d8aade1 fix: update change lead time (#3410)
8d8aade1 is described below
commit 8d8aade109ba2b960eec3ecbb5067678a43a81d7
Author: Klesh Wong <zh...@merico.dev>
AuthorDate: Thu Oct 13 10:03:06 2022 +0800
fix: update change lead time (#3410)
Co-authored-by: Startrekzky <ka...@merico.dev>
---
grafana/dashboards/DORA.json | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
diff --git a/grafana/dashboards/DORA.json b/grafana/dashboards/DORA.json
index 2b8bd05e..644734bf 100644
--- a/grafana/dashboards/DORA.json
+++ b/grafana/dashboards/DORA.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 2,
+ "id": 19,
"links": [],
"panels": [
{
@@ -142,7 +142,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": [
[
@@ -340,7 +340,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 2: median change lead time per month\nwith _deployment_change_lead_time as (\n-- get one deployment's change lead time\n\tSELECT\n\t\tct.id as deployment_id,\n\t\tct.name as deployment_name,\n\t\tct.finished_date as deployed_at,\n\t\tavg(pr.change_timespan) as change_lead_time_of_a_deployment\n\tFROM\n\t\tcicd_tasks ct \n\t\tjoin cicd_pipeline_commits cpc on ct.pipeline_id = cpc.pipeline_id\n\t\tjoin pull_requests pr on cpc.commit_sha = pr.merge_commit_sha\ [...]
+ "rawSql": "-- Metric 2: median change lead time\nwith _pr_stats as (\n-- get PRs' cycle time in the selected period\n\tSELECT\n\t\tpr.id,\n\t\tpr.change_timespan as pr_cycle_time\n\tFROM\n\t\tpull_requests pr\n\tWHERE\n\t\tpr.merged_date is not null\n\t\tand pr.change_timespan is not null\n\t\tand $__timeFilter(pr.merged_date)\n),\n\n_median_change_lead_time as (\n-- use median PR cycle time as the median change lead time\n\tSELECT x.pr_cycle_time as median_change_lead_time fro [...]
"refId": "A",
"select": [
[
@@ -364,7 +364,7 @@
]
}
],
- "title": "Lead Time for Changes",
+ "title": "Median Lead Time for Changes",
"type": "stat"
},
{
@@ -726,7 +726,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "-- Metric 2: median change lead time per month\nwith _deployment_change_lead_time as (\n-- to get one deployment's mean change lead time\n\tSELECT\n\t\tct.id as deployment_id,\n\t\tct.name as deployment_name,\n\t\tdate_format(ct.finished_date,'%y/%m') as month,\n\t\tavg(pr.change_timespan) as change_lead_time_of_a_deployment\n\tFROM\n\t\tcicd_tasks ct \n\t\tjoin cicd_pipeline_commits cpc on ct.pipeline_id = cpc.pipeline_id\n\t\tjoin pull_requests pr on cpc.commit_sha [...]
+ "rawSql": "-- Metric 2: median change lead time per month\nwith _pr_stats as (\n-- get PRs' cycle lead time in each month\n\tSELECT\n\t\tpr.id,\n\t\tdate_format(pr.merged_date,'%y/%m') as month,\n\t\tpr.change_timespan as pr_cycle_time\n\tFROM\n\t\tpull_requests pr\n\tWHERE\n\t\tpr.merged_date is not null\n\t\tand pr.change_timespan is not null\n\t\tand $__timeFilter(pr.merged_date)\n),\n\n_find_median_clt_each_month as (\n\tSELECT x.month, x.pr_cycle_time as med_change_lead_ti [...]
"refId": "A",
"select": [
[
@@ -752,7 +752,7 @@
],
"timeFrom": null,
"timeShift": null,
- "title": "Lead Time for Changes",
+ "title": "Median Lead Time for Changes",
"type": "barchart"
},
{