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 <[email protected]> AuthorDate: Thu Oct 13 10:03:06 2022 +0800 fix: update change lead time (#3410) Co-authored-by: Startrekzky <[email protected]> --- 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" }, {
