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 2023/03/30 03:03:20 UTC

[incubator-devlake] branch main updated: fix: Median Lead Time for Changes from a different blueprint/project (#4816)

This is an automated email from the ASF dual-hosted git repository.

zky 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 1d9556da7 fix: Median Lead Time for Changes from a different blueprint/project (#4816)
1d9556da7 is described below

commit 1d9556da76cc3a647cf9293e7464e22ba834c7e1
Author: abeizn <zi...@merico.dev>
AuthorDate: Thu Mar 30 11:03:13 2023 +0800

    fix: Median Lead Time for Changes from a different blueprint/project (#4816)
    
    * fix: Mean Lead Time for Changes from a different blueprint/project
    
    * fix: Mean Lead Time for Changes from a different blueprint/project
---
 grafana/dashboards/DORA.json | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/grafana/dashboards/DORA.json b/grafana/dashboards/DORA.json
index 141aee61b..ac94804ae 100644
--- a/grafana/dashboards/DORA.json
+++ b/grafana/dashboards/DORA.json
@@ -15,8 +15,8 @@
   "editable": true,
   "gnetId": null,
   "graphTooltip": 0,
-  "id": 26,
-  "iteration": 1679477723625,
+  "id": 27,
+  "iteration": 1680142836842,
   "links": [],
   "panels": [
     {
@@ -727,7 +727,7 @@
           "hide": false,
           "metricColumn": "none",
           "rawQuery": true,
-          "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\tdistinct pr.id,\n\t\tdate_format(pr.merged_date,'%y/%m') as month,\n\t\tprm.pr_cycle_time\n\tFROM\n\t\tpull_requests pr\n\t\tjoin project_pr_metrics prm on prm.id = pr.id\n\t\tjoin project_mapping pm on pr.base_repo_id = pm.row_id\n\tWHERE\n\t\tpr.merged_date is not null\n\t\tand prm.pr_cycle_time is not null\n\t\tand $__timeFilter(pr.merged_d [...]
+          "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\tdistinct pr.id,\n\t\tdate_format(pr.merged_date,'%y/%m') as month,\n\t\tprm.pr_cycle_time\n\tFROM\n\t\tpull_requests pr\n\t\tjoin project_pr_metrics prm on prm.id = pr.id\n\t\tjoin project_mapping pm on pr.base_repo_id = pm.row_id\n\tWHERE\n\t\tpm.project_name in ($project) \n\t\tand pr.merged_date is not null\n\t\tand prm.pr_cycle_time is not [...]
           "refId": "A",
           "select": [
             [
@@ -1025,5 +1025,5 @@
   "timezone": "",
   "title": "DORA",
   "uid": "qNo8_0M4z",
-  "version": 19
+  "version": 3
 }
\ No newline at end of file