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 2023/05/10 11:05:22 UTC

[incubator-devlake] branch main updated: fix: Jenkins Build Success Rate Graph disordered (#5150)

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 35dba4671 fix: Jenkins Build Success Rate Graph disordered (#5150)
35dba4671 is described below

commit 35dba4671c613a7c76128864fdafab8bb381080d
Author: Louis.z <lo...@gmail.com>
AuthorDate: Wed May 10 19:05:17 2023 +0800

    fix: Jenkins Build Success Rate Graph disordered (#5150)
    
    Co-authored-by: Startrekzky <ka...@merico.dev>
---
 grafana/dashboards/Jenkins.json | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/grafana/dashboards/Jenkins.json b/grafana/dashboards/Jenkins.json
index fc72fe2c3..f2fc39197 100644
--- a/grafana/dashboards/Jenkins.json
+++ b/grafana/dashboards/Jenkins.json
@@ -15,8 +15,8 @@
   "editable": true,
   "gnetId": null,
   "graphTooltip": 0,
-  "id": 4,
-  "iteration": 1682063024677,
+  "id": 6,
+  "iteration": 1683624526469,
   "links": [],
   "panels": [
     {
@@ -624,7 +624,7 @@
           "group": [],
           "metricColumn": "none",
           "rawQuery": true,
-          "rawSql": "WITH _build_success_rate as(\r\n  SELECT\r\n    DATE_ADD(date(finished_date), INTERVAL -DAYOFMONTH(date(finished_date))+1 DAY) as time,\r\n    result\r\n  FROM\r\n    cicd_pipelines\r\n  WHERE\r\n    $__timeFilter(finished_date)\r\n    and id like \"%jenkins%\"\r\n    and cicd_scope_id in ($job_id)\r\n    -- the following condition will remove the month with incomplete data\r\n    and finished_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DA [...]
+          "rawSql": "WITH _build_success_rate as(\r\n  SELECT\r\n    DATE_ADD(date(finished_date), INTERVAL -DAYOFMONTH(date(finished_date))+1 DAY) as time,\r\n    result\r\n  FROM\r\n    cicd_pipelines\r\n  WHERE\r\n    $__timeFilter(finished_date)\r\n    and id like \"%jenkins%\"\r\n    and cicd_scope_id in ($job_id)\r\n    -- the following condition will remove the month with incomplete data\r\n    and finished_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DA [...]
           "refId": "A",
           "select": [
             [
@@ -800,7 +800,7 @@
             "mode": "palette-classic"
           },
           "custom": {
-            "axisLabel": "Build Count",
+            "axisLabel": "Build Duration(minutes)",
             "axisPlacement": "auto",
             "axisSoftMin": 0,
             "fillOpacity": 80,
@@ -971,5 +971,5 @@
   "timezone": "",
   "title": "Jenkins",
   "uid": "W8AiDFQnk",
-  "version": 3
+  "version": 2
 }
\ No newline at end of file