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 ae30be10f fix(dashboard): update circleci dashboard (#6871)
ae30be10f is described below
commit ae30be10fc2f54f98a98d8ac8f315fd85f34a956
Author: Lynwee <[email protected]>
AuthorDate: Fri Jan 26 11:57:03 2024 +0800
fix(dashboard): update circleci dashboard (#6871)
---
grafana/dashboards/CircleCI.json | 16 ++++++++--------
1 file changed, 8 insertions(+), 8 deletions(-)
diff --git a/grafana/dashboards/CircleCI.json b/grafana/dashboards/CircleCI.json
index e304e9463..b8d61e1cc 100644
--- a/grafana/dashboards/CircleCI.json
+++ b/grafana/dashboards/CircleCI.json
@@ -120,7 +120,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n count(distinct id)\nFROM \n
cicd_pipelines\nWHERE\n $__timeFilter(finished_date)\n and result =
'SUCCESS'\n and id like \"%circleci%\"\n and cicd_scope_id in ($full_name)\n
-- the following condition will remove the month with incomplete data\n and
finished_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL
-DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)",
+ "rawSql": "SELECT\n count(distinct id)\nFROM \n
cicd_pipelines\nWHERE\n $__timeFilter(finished_date)\n and result =
'SUCCESS'\n and id like \"%circleci%\"\n and cicd_scope_id in
(${full_name:sqlstring}+'')\n -- the following condition will remove the month
with incomplete data\n and finished_date >= DATE_ADD(DATE_ADD($__timeFrom(),
INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)",
"refId": "A",
"select": [
[
@@ -223,7 +223,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n 1.0 * count(case when result = 'SUCCESS' then
id else null end)/count(distinct id)\nFROM cicd_pipelines\nWHERE\n
$__timeFilter(finished_date)\n and id like \"%circleci%\"\n and cicd_scope_id
in ($full_name)\n -- the following condition will remove the month with
incomplete data\n and finished_date >= DATE_ADD(DATE_ADD($__timeFrom(),
INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)",
+ "rawSql": "SELECT\n 1.0 * count(case when result = 'SUCCESS' then
id else null end)/count(distinct id)\nFROM cicd_pipelines\nWHERE\n
$__timeFilter(finished_date)\n and id like \"%circleci%\"\n and cicd_scope_id
in (${full_name:sqlstring}+'')\n -- the following condition will remove the
month with incomplete data\n and finished_date >=
DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL
+1 MONTH)",
"refId": "A",
"select": [
[
@@ -410,7 +410,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n result,\n count(distinct id) as
build_count\nFROM cicd_pipelines\nWHERE\n $__timeFilter(finished_date)\n and
id like \"%circleci%\"\n and cicd_scope_id in ($full_name)\n -- the following
condition will remove the month with incomplete data\n and finished_date >=
DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL
+1 MONTH)\nGROUP BY 1\nORDER BY 2 desc",
+ "rawSql": "SELECT\n result,\n count(distinct id) as
build_count\nFROM cicd_pipelines\nWHERE\n $__timeFilter(finished_date)\n and
id like \"%circleci%\"\n and cicd_scope_id in (${full_name:sqlstring}+'')\n
-- the following condition will remove the month with incomplete data\n and
finished_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL
-DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)\nGROUP BY 1\nORDER BY 2 desc",
"refId": "A",
"select": [
[
@@ -510,7 +510,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n avg(duration_sec/60) as
duration_in_minutes\nFROM cicd_pipelines\nWHERE\n
$__timeFilter(finished_date)\n and id like \"%circleci%\"\n and cicd_scope_id
in ($full_name)\n -- the following condition will remove the month with
incomplete data\n and finished_date >= DATE_ADD(DATE_ADD($__timeFrom(),
INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)",
+ "rawSql": "SELECT\n avg(duration_sec/60) as
duration_in_minutes\nFROM cicd_pipelines\nWHERE\n
$__timeFilter(finished_date)\n and id like \"%circleci%\"\n and cicd_scope_id
in (${full_name:sqlstring}+'')\n -- the following condition will remove the
month with incomplete data\n and finished_date >=
DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL
+1 MONTH)",
"refId": "A",
"select": [
[
@@ -631,7 +631,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "WITH _builds as(\n SELECT\n
DATE_ADD(date(finished_date), INTERVAL -DAYOFMONTH(date(finished_date))+1 DAY)
as time,\n count(distinct id) as build_count\n FROM cicd_pipelines\n
WHERE\n $__timeFilter(finished_date)\n and result = 'SUCCESS'\n and id
like \"%circleci%\"\n and cicd_scope_id in ($full_name)\n -- the
following condition will remove the month with incomplete data\n and
finished_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY [...]
+ "rawSql": "WITH _builds as(\n SELECT\n
DATE_ADD(date(finished_date), INTERVAL -DAYOFMONTH(date(finished_date))+1 DAY)
as time,\n count(distinct id) as build_count\n FROM cicd_pipelines\n
WHERE\n $__timeFilter(finished_date)\n and result = 'SUCCESS'\n and id
like \"%circleci%\"\n and cicd_scope_id in (${full_name:sqlstring}+'')\n
-- the following condition will remove the month with incomplete data\n and
finished_date >= DATE_ADD(DATE_ADD($__timeFrom() [...]
"refId": "A",
"select": [
[
@@ -788,7 +788,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 id\r\n FROM\r\n cicd_pipelines\r\n
WHERE\r\n $__timeFilter(finished_date)\r\n and id like \"%circleci%\"\r\n
and cicd_scope_id in ($full_name)\r\n -- the following condition will
remove the month with incomplete data\r\n and finished_date >=
DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__t [...]
+ "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 id\r\n FROM\r\n cicd_pipelines\r\n
WHERE\r\n $__timeFilter(finished_date)\r\n and id like \"%circleci%\"\r\n
and cicd_scope_id in (${full_name:sqlstring}+'')\r\n -- the following
condition will remove the month with incomplete data\r\n and finished_date
>= DATE_ADD(DATE_ADD($__timeFrom(), INT [...]
"refId": "A",
"select": [
[
@@ -955,7 +955,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n DATE_ADD(date(finished_date), INTERVAL
-DAYOFMONTH(date(finished_date))+1 DAY) as time,\n count(distinct case when
result = 'SUCCESS' then id else null end) as successful_build_count,\n
count(distinct case when result != 'SUCCESS' then id else null end) as
failed_build_count\nFROM cicd_pipelines\nWHERE\n
$__timeFilter(finished_date)\n and id like \"%circleci%\"\n and cicd_scope_id
in ($full_name)\n -- the following condition will remove the month with [...]
+ "rawSql": "SELECT\n DATE_ADD(date(finished_date), INTERVAL
-DAYOFMONTH(date(finished_date))+1 DAY) as time,\n count(distinct case when
result = 'SUCCESS' then id else null end) as successful_build_count,\n
count(distinct case when result != 'SUCCESS' then id else null end) as
failed_build_count\nFROM cicd_pipelines\nWHERE\n
$__timeFilter(finished_date)\n and id like \"%circleci%\"\n and cicd_scope_id
in (${full_name:sqlstring}+'')\n -- the following condition will remove [...]
"refId": "A",
"select": [
[
@@ -1091,7 +1091,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "WITH _builds as(\n SELECT\n
DATE_ADD(date(finished_date), INTERVAL -DAYOFMONTH(date(finished_date))+1 DAY)
as time,\n avg(duration_sec) as mean_duration_sec\n FROM \n
cicd_pipelines\n WHERE\n $__timeFilter(finished_date)\n and id like
\"%circleci%\"\n and cicd_scope_id in ($full_name)\n -- the following
condition will remove the month with incomplete data\n and finished_date >=
DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 [...]
+ "rawSql": "WITH _builds as(\n SELECT\n
DATE_ADD(date(finished_date), INTERVAL -DAYOFMONTH(date(finished_date))+1 DAY)
as time,\n avg(duration_sec) as mean_duration_sec\n FROM \n
cicd_pipelines\n WHERE\n $__timeFilter(finished_date)\n and id like
\"%circleci%\"\n and cicd_scope_id in (${full_name:sqlstring}+'')\n --
the following condition will remove the month with incomplete data\n and
finished_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($ [...]
"refId": "A",
"select": [
[
