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 2022/10/13 08:32:25 UTC
[incubator-devlake] branch release-v0.14 created (now 8d8aade1)
This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a change to branch release-v0.14
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
at 8d8aade1 fix: update change lead time (#3410)
This branch includes the following new commits:
new 8d8aade1 fix: update change lead time (#3410)
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
[incubator-devlake] 01/01: fix: update change lead time (#3410)
Posted by ab...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a commit to branch release-v0.14
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
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"
},
{