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 ed29131a0 fix: case inconsistency in sql (#4997)
ed29131a0 is described below
commit ed29131a0b1ff9ef866d8abb29fa791d6e04a3be
Author: abeizn <[email protected]>
AuthorDate: Fri Apr 21 17:31:40 2023 +0800
fix: case inconsistency in sql (#4997)
* fix: case inconsistency in sql
* fix: weekly bug retro select repo
---
grafana/dashboards/BitBucket.json | 6 +++---
grafana/dashboards/ComponentAndFileLevelMetrics.json | 8 ++++----
grafana/dashboards/ContributorExperience.json | 12 ++++++------
grafana/dashboards/DORA.json | 12 ++++++------
.../DemoAverageRequirementLeadTimeByAssignee.json | 8 ++++----
grafana/dashboards/DemoCommitCountByAuthor.json | 4 ++--
grafana/dashboards/DemoDetailedBugInfo.json | 8 ++++----
...DemoHowFastDoWeRespondToCustomerRequirements.json | 4 ++--
.../DemoIsThisMonthMoreProductiveThanLast.json | 4 ++--
.../dashboards/DemoWasOurQualityImprovedOrNot.json | 4 ++--
grafana/dashboards/EngineeringOverview.json | 6 +++---
.../EngineeringThroughputAndCycleTime.json | 6 +++---
.../EngineeringThroughputAndCycleTimeTeamView.json | 6 +++---
grafana/dashboards/GitHub.json | 20 ++++++++++----------
.../GithubReleaseQualityAndContributionAnalysis.json | 6 +++---
grafana/dashboards/Gitlab.json | 18 +++++++++---------
grafana/dashboards/Jenkins.json | 6 +++---
grafana/dashboards/Jira.json | 6 +++---
grafana/dashboards/Sonarqube.json | 12 ++++++------
grafana/dashboards/TAPD.json | 4 ++--
grafana/dashboards/WeeklyBugRetro.json | 4 ++--
grafana/dashboards/WeeklyCommunityRetro.json | 6 +++---
22 files changed, 85 insertions(+), 85 deletions(-)
diff --git a/grafana/dashboards/BitBucket.json
b/grafana/dashboards/BitBucket.json
index 45ccaf825..0d2060d66 100644
--- a/grafana/dashboards/BitBucket.json
+++ b/grafana/dashboards/BitBucket.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 12,
- "iteration": 1679476420040,
+ "id": 28,
+ "iteration": 1682062771301,
"links": [],
"panels": [
{
@@ -966,5 +966,5 @@
"timezone": "",
"title": "BitBucket",
"uid": "4LzQHZa4k",
- "version": 16
+ "version": 1
}
\ No newline at end of file
diff --git a/grafana/dashboards/ComponentAndFileLevelMetrics.json
b/grafana/dashboards/ComponentAndFileLevelMetrics.json
index ab49cce0e..d8f08e498 100644
--- a/grafana/dashboards/ComponentAndFileLevelMetrics.json
+++ b/grafana/dashboards/ComponentAndFileLevelMetrics.json
@@ -16,8 +16,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 17,
- "iteration": 1677030964408,
+ "id": 20,
+ "iteration": 1682062815355,
"links": [],
"panels": [
{
@@ -991,7 +991,7 @@
{
"allValue": null,
"current": {
- "selected": false,
+ "selected": true,
"text": [
"All"
],
@@ -1061,5 +1061,5 @@
"timezone": "",
"title": "Component and File-level Metrics",
"uid": "KxUh7IG4z",
- "version": 4
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/ContributorExperience.json
b/grafana/dashboards/ContributorExperience.json
index 678b3c4ab..9a77d2294 100644
--- a/grafana/dashboards/ContributorExperience.json
+++ b/grafana/dashboards/ContributorExperience.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 21,
- "iteration": 1677590412757,
+ "id": 24,
+ "iteration": 1682062826895,
"links": [],
"panels": [
{
@@ -508,7 +508,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql":
"select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as
time_to_close\nfrom \n\tpull_requests pr\nwhere \n date(created_date)
BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1
month and\n curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n\tand status in
('closed', 'merged', 'declined')\n\tand pr.base_repo_id in ($repo_id)\n\n\n",
+ "rawSql":
"select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as
time_to_close\nfrom \n\tpull_requests pr\nwhere \n date(created_date)
BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1
month and\n curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n\tand status in
('CLOSED', 'MERGED', 'DECLINED')\n\tand pr.base_repo_id in ($repo_id)\n\n\n",
"refId": "A",
"select": [
[
@@ -590,7 +590,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n 100 * sum(case when TIMESTAMPDIFF(Minute,
created_date, closed_date) / 1440 < $prrt_sla then 1 else null end) /
count(*)\nfrom \n\tpull_requests pr\nwhere \n date(created_date) BETWEEN\n
curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month and\n
curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n\tand status in ('closed',
'merged', 'declined')\n\tand pr.base_repo_id in ($repo_id)\n\n\n",
+ "rawSql": "select\n 100 * sum(case when TIMESTAMPDIFF(Minute,
created_date, closed_date) / 1440 < $prrt_sla then 1 else null end) /
count(*)\nfrom \n\tpull_requests pr\nwhere \n date(created_date) BETWEEN\n
curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month and\n
curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n\tand status in ('CLOSED',
'MERGED', 'DECLINED')\n\tand pr.base_repo_id in ($repo_id)\n\n\n",
"refId": "A",
"select": [
[
@@ -672,7 +672,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n 100 * count(distinct case when status in
('closed', 'merged', 'declined') and merged_date is null then id else null
end)/count(distinct case when status in ('closed', 'merged', 'declined') then
id else null end) as ratio\nfrom \n\tpull_requests pr\nwhere\n
date(created_date) BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1
DAY - INTERVAL 1 month and\n curdate() - INTERVAL DAYOFMONTH(curdate())
DAY\n and pr.base_repo_id in ($repo_id)",
+ "rawSql": "select\n 100 * count(distinct case when status in
('CLOSED', 'MERGED', 'DECLINED') and merged_date is null then id else null
end)/count(distinct case when status in ('CLOSED', 'MERGED', 'DECLINED') then
id else null end) as ratio\nfrom \n\tpull_requests pr\nwhere\n
date(created_date) BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1
DAY - INTERVAL 1 month and\n curdate() - INTERVAL DAYOFMONTH(curdate())
DAY\n and pr.base_repo_id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -828,5 +828,5 @@
"timezone": "",
"title": "Contributor Experience",
"uid": "bwsP5Nz4z",
- "version": 6
+ "version": 9
}
\ No newline at end of file
diff --git a/grafana/dashboards/DORA.json b/grafana/dashboards/DORA.json
index ab0cf6730..a6a5babf5 100644
--- a/grafana/dashboards/DORA.json
+++ b/grafana/dashboards/DORA.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 12,
- "iteration": 1681911584843,
+ "id": 9,
+ "iteration": 1682062927185,
"links": [],
"panels": [
{
@@ -143,7 +143,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": [
[
@@ -543,7 +543,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Metric 4: change failure rate\nwith _deployments as
(\n-- get the deployment deployed within the selected time period in the
top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date
as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin
project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t
pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result =
'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...]
+ "rawSql": "-- Metric 4: change failure rate\nwith _deployments as
(\n-- get the deployment deployed within the selected time period in the
top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date
as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin
project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t
pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result =
'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...]
"refId": "A",
"select": [
[
@@ -953,7 +953,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "-- Metric 4: change failure rate\nwith _deployments as
(\n-- get the deployment deployed within the selected time period in the
top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date
as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin
project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t
pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result =
'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...]
+ "rawSql": "-- Metric 4: change failure rate\nwith _deployments as
(\n-- get the deployment deployed within the selected time period in the
top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date
as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin
project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t
pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result =
'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...]
"refId": "A",
"select": [
[
@@ -1027,5 +1027,5 @@
"timezone": "",
"title": "DORA",
"uid": "qNo8_0M4z",
- "version": 2
+ "version": 13
}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json
b/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json
index 38297e291..3f17d0143 100644
--- a/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json
+++ b/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 3,
+ "id": 1,
"links": [
{
"asDropdown": false,
@@ -111,7 +111,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _requirements as(\n select \n
DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as
time,\n assignee_name as assignee,\n avg(lead_time_minutes)/1440 as
lead_time\n from issues i\n where \n type = 'Requirement'\n and
assignee_id != ''\n and $__timeFilter(resolution_date)\n group by
1,2\n),\n\n\nthis_month as(\n\tselect \n\t\tDATE_ADD(date(CURDATE()), INTERVAL
-DAY(date(CURDATE()))+1 DAY) as this_month\n),\n\nlast_mon [...]
+ "rawSql": "with _requirements as(\n select \n
DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as
time,\n assignee_name as assignee,\n avg(lead_time_minutes)/1440 as
lead_time\n from issues i\n where \n type = 'REQUIREMENT'\n and
assignee_id != ''\n and $__timeFilter(resolution_date)\n group by
1,2\n),\n\n\nthis_month as(\n\tselect \n\t\tDATE_ADD(date(CURDATE()), INTERVAL
-DAY(date(CURDATE()))+1 DAY) as this_month\n),\n\nlast_mon [...]
"refId": "A",
"select": [
[
@@ -182,7 +182,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _requirements as(\n select \n
DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as
time,\n assignee_name as assignee,\n avg(lead_time_minutes)/1440 as
lead_time\n from issues i\n where \n type = 'Requirement'\n and
assignee_id != ''\n and $__timeFilter(resolution_date)\n group by
1,2\n),\n\n\nthis_month as(\n\tselect \n\t\tDATE_ADD(date(CURDATE()), INTERVAL
-DAY(date(CURDATE()))+1 DAY) as this_month\n),\n\nlast_mon [...]
+ "rawSql": "with _requirements as(\n select \n
DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as
time,\n assignee_name as assignee,\n avg(lead_time_minutes)/1440 as
lead_time\n from issues i\n where \n type = 'REQUIREMENT'\n and
assignee_id != ''\n and $__timeFilter(resolution_date)\n group by
1,2\n),\n\n\nthis_month as(\n\tselect \n\t\tDATE_ADD(date(CURDATE()), INTERVAL
-DAY(date(CURDATE()))+1 DAY) as this_month\n),\n\nlast_mon [...]
"refId": "A",
"select": [
[
@@ -246,5 +246,5 @@
"timezone": "",
"title": "Demo-Average Requirement Lead Time By Assignee",
"uid": "q27fk7cnk",
- "version": 2
+ "version": 6
}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoCommitCountByAuthor.json
b/grafana/dashboards/DemoCommitCountByAuthor.json
index 57a6c8914..e98fcf702 100644
--- a/grafana/dashboards/DemoCommitCountByAuthor.json
+++ b/grafana/dashboards/DemoCommitCountByAuthor.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 4,
+ "id": 5,
"links": [
{
"asDropdown": false,
@@ -253,5 +253,5 @@
"timezone": "",
"title": "Demo-Commit Count by Author",
"uid": "F0iYknc7z",
- "version": 2
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoDetailedBugInfo.json
b/grafana/dashboards/DemoDetailedBugInfo.json
index 602599cab..df10f937d 100644
--- a/grafana/dashboards/DemoDetailedBugInfo.json
+++ b/grafana/dashboards/DemoDetailedBugInfo.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 10,
+ "id": 2,
"links": [
{
"asDropdown": false,
@@ -114,7 +114,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with bugs as(\n select \n
DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as
time,\n count(*) as bug_count\n from issues i\n where \n type = 'Bug'\n
and $__timeFilter(created_date)\n group by 1\n order by 1
desc\n)\n\nselect\n date_format(time,'%M %Y') as month,\n bug_count as 'Bug
Count over Month'\nfrom bugs\norder by time asc",
+ "rawSql": "with bugs as(\n select \n
DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as
time,\n count(*) as bug_count\n from issues i\n where \n type = 'BUG'\n
and $__timeFilter(created_date)\n group by 1\n order by 1
desc\n)\n\nselect\n date_format(time,'%M %Y') as month,\n bug_count as 'Bug
Count over Month'\nfrom bugs\norder by time asc",
"refId": "A",
"select": [
[
@@ -249,7 +249,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n title,\n description,\n case when
assignee_id = '' then '-' else assignee_name end as assignee,\n status,\n
created_date,\n url\n from issues i\n where \n type = 'Bug'\n and
$__timeFilter(created_date)\n order by created_date desc",
+ "rawSql": "select \n title,\n description,\n case when
assignee_id = '' then '-' else assignee_name end as assignee,\n status,\n
created_date,\n url\n from issues i\n where \n type = 'BUG'\n and
$__timeFilter(created_date)\n order by created_date desc",
"refId": "A",
"select": [
[
@@ -311,5 +311,5 @@
"timezone": "",
"title": "Demo-Detailed Bug Info",
"uid": "s48Lzn5nz",
- "version": 2
+ "version": 8
}
\ No newline at end of file
diff --git
a/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json
b/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json
index f3824b28b..863541eb4 100644
--- a/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json
+++ b/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json
@@ -108,7 +108,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "with _requirements as(\n select \n
DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as
time,\n avg(lead_time_minutes)/1440 as lead_time_days\n from issues i\n
where \n type = 'Requirement'\n and $__timeFilter(resolution_date)\n
group by time\n)\n\nselect\n date_format(time,'%M %Y') as month,\n
lead_time_days as 'Average Requirement Lead Time (day)'\nfrom
_requirements\norder by time asc",
+ "rawSql": "with _requirements as(\n select \n
DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as
time,\n avg(lead_time_minutes)/1440 as lead_time_days\n from issues i\n
where \n type = 'REQUIREMENT'\n and $__timeFilter(resolution_date)\n
group by time\n)\n\nselect\n date_format(time,'%M %Y') as month,\n
lead_time_days as 'Average Requirement Lead Time (day)'\nfrom
_requirements\norder by time asc",
"refId": "A",
"select": [
[
@@ -219,5 +219,5 @@
"timezone": "",
"title": "Demo-How fast do we respond to customer requirements?",
"uid": "SupYz7c7z",
- "version": 2
+ "version": 4
}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json
b/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json
index a3a0def17..520b41f7c 100644
--- a/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json
+++ b/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 5,
+ "id": 12,
"links": [
{
"asDropdown": false,
@@ -249,5 +249,5 @@
"timezone": "",
"title": "Demo-Is this month more productive than last?",
"uid": "ddREk75nk",
- "version": 2
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json
b/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json
index 7d9e2c787..acb70c618 100644
--- a/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json
+++ b/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json
@@ -109,7 +109,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with line_of_code as (\n\tselect \n\t
DATE_ADD(date(authored_date), INTERVAL -DAY(date(authored_date))+1 DAY) as
time,\n\t sum(additions + deletions) as line_count\n\tfrom \n\t
commits\n\twhere \n\t message not like 'Merge%'\n\t and
$__timeFilter(authored_date)\n\tgroup by 1\n),\n\n\nbug_count as(\n select \n
DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as
time,\n count(*) as bug_count\n from issues i\n where \n type = 'Bug'\
[...]
+ "rawSql": "with line_of_code as (\n\tselect \n\t
DATE_ADD(date(authored_date), INTERVAL -DAY(date(authored_date))+1 DAY) as
time,\n\t sum(additions + deletions) as line_count\n\tfrom \n\t
commits\n\twhere \n\t message not like 'Merge%'\n\t and
$__timeFilter(authored_date)\n\tgroup by 1\n),\n\n\nbug_count as(\n select \n
DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as
time,\n count(*) as bug_count\n from issues i\n where \n type = 'BUG'\
[...]
"refId": "A",
"select": [
[
@@ -216,5 +216,5 @@
"timezone": "",
"title": "Demo-Was our quality improved or not?",
"uid": "G4DEk75nz",
- "version": 2
+ "version": 4
}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringOverview.json
b/grafana/dashboards/EngineeringOverview.json
index 9fd1c7a00..4749fda62 100644
--- a/grafana/dashboards/EngineeringOverview.json
+++ b/grafana/dashboards/EngineeringOverview.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 26,
- "iteration": 1671764846277,
+ "id": 25,
+ "iteration": 1682062941722,
"links": [],
"panels": [
{
@@ -1845,5 +1845,5 @@
"timezone": "",
"title": "Engineering Overview",
"uid": "ZF6abXX7z",
- "version": 5
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTime.json
b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
index cc3661303..eeeb80ed3 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTime.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 11,
- "iteration": 1673349403459,
+ "id": 13,
+ "iteration": 1682062957718,
"links": [],
"panels": [
{
@@ -1645,5 +1645,5 @@
"timezone": "",
"title": "Engineering Throughput and Cycle Time",
"uid": "Jaaimc67k",
- "version": 9
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
index 62cc0cc3b..dad862bf8 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 12,
- "iteration": 1673353935665,
+ "id": 7,
+ "iteration": 1682062968493,
"links": [],
"panels": [
{
@@ -2778,5 +2778,5 @@
"timezone": "",
"title": "Engineering Throughput and Cycle Time - Team View",
"uid": "nJ1ijje7k",
- "version": 2
+ "version": 6
}
\ No newline at end of file
diff --git a/grafana/dashboards/GitHub.json b/grafana/dashboards/GitHub.json
index 6fe6c5806..30fee78dc 100644
--- a/grafana/dashboards/GitHub.json
+++ b/grafana/dashboards/GitHub.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 25,
- "iteration": 1677590489731,
+ "id": 3,
+ "iteration": 1682062979883,
"links": [],
"panels": [
{
@@ -1164,7 +1164,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n author_name,\n\tcount(*) as
merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n
$__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n and pr.status
in ('closed', 'merged', 'declined') and pr.merged_date is not null\ngroup by
1\norder by 2 desc\nlimit 20\n",
+ "rawSql": "select\n author_name,\n\tcount(*) as
merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n
$__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n and pr.status
in ('CLOSED', 'MERGED', 'DECLINED') and pr.merged_date is not null\ngroup by
1\norder by 2 desc\nlimit 20\n",
"refId": "A",
"select": [
[
@@ -1259,7 +1259,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n count(distinct case when status in ('closed',
'merged') and merged_date is not null then id else null end)/count(distinct
case when status in ('closed', 'merged') then id else null end) as ratio\nfrom
\n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id
in ($repo_id)",
+ "rawSql": "select\n count(distinct case when status in ('CLOSED',
'MERGED') and merged_date is not null then id else null end)/count(distinct
case when status in ('CLOSED', 'MERGED') then id else null end) as ratio\nfrom
\n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id
in ($repo_id)",
"refId": "A",
"select": [
[
@@ -1362,7 +1362,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL
-DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when
status != 'closed' then id else null end) as \"PR: Open\",\n count(distinct
case when status in ('closed', 'merged') and merged_date is null then id else
null end) as \"PR: Closed without merging\",\n count(distinct case when
status in ('closed', 'merged') then id else null end) as \"PR: Closed and
merged\"\nFROM pull_requests\nWHERE\n $__ti [...]
+ "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL
-DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when
status != 'CLOSED' then id else null end) as \"PR: Open\",\n count(distinct
case when status in ('CLOSED', 'MERGED') and merged_date is null then id else
null end) as \"PR: Closed without merging\",\n count(distinct case when
status in ('CLOSED', 'MERGED') then id else null end) as \"PR: Closed and
merged\"\nFROM pull_requests\nWHERE\n $__ti [...]
"refId": "A",
"select": [
[
@@ -1444,7 +1444,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom
\n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id
in ($repo_id)\n\tand pr.status in ('closed', 'merged') and pr.merged_date is
null",
+ "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom
\n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id
in ($repo_id)\n\tand pr.status in ('CLOSED', 'MERGED') and pr.merged_date is
null",
"refId": "A",
"select": [
[
@@ -1549,7 +1549,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL
-DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when
status in ('closed', 'merged') and merged_date is null then id else null
end)/count(distinct case when status in ('closed', 'merged') then id else null
end) as ratio\nFROM pull_requests\nWHERE\n $__timeFilter(created_date)\n and
base_repo_id in ($repo_id)\ngroup by 1\n",
+ "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL
-DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when
status in ('CLOSED', 'MERGED') and merged_date is null then id else null
end)/count(distinct case when status in ('CLOSED', 'MERGED') then id else null
end) as ratio\nFROM pull_requests\nWHERE\n $__timeFilter(created_date)\n and
base_repo_id in ($repo_id)\ngroup by 1\n",
"refId": "A",
"select": [
[
@@ -1808,7 +1808,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql":
"select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as
time_to_close\nfrom \n\tpull_requests\nwhere \n
$__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand status in
('closed', 'merged')\n\n\n",
+ "rawSql":
"select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as
time_to_close\nfrom \n\tpull_requests\nwhere \n
$__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand status in
('CLOSED', 'MERGED')\n\n\n",
"refId": "A",
"select": [
[
@@ -1905,7 +1905,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "with _prs as(\n SELECT\n DATE_ADD(date(created_date),
INTERVAL -DAY(date(created_date))+1 DAY) as time,\n
avg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\n
FROM pull_requests\n WHERE\n $__timeFilter(created_date)\n and
created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1
DAY), INTERVAL +1 MONTH)\n and base_repo_id in ($repo_id)\n and status in
('closed', 'merged')\n group by 1\n)\n\nSELECT \n [...]
+ "rawSql": "with _prs as(\n SELECT\n DATE_ADD(date(created_date),
INTERVAL -DAY(date(created_date))+1 DAY) as time,\n
avg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\n
FROM pull_requests\n WHERE\n $__timeFilter(created_date)\n and
created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1
DAY), INTERVAL +1 MONTH)\n and base_repo_id in ($repo_id)\n and status in
('CLOSED', 'MERGED')\n group by 1\n)\n\nSELECT \n [...]
"refId": "A",
"select": [
[
@@ -1999,5 +1999,5 @@
"timezone": "",
"title": "GitHub",
"uid": "KXWvOFQnz",
- "version": 10
+ "version": 13
}
\ No newline at end of file
diff --git
a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
index 1642e5370..aa8b9bcc7 100644
--- a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
+++ b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 7,
- "iteration": 1668494309227,
+ "id": 22,
+ "iteration": 1682062991983,
"links": [],
"panels": [
{
@@ -2646,5 +2646,5 @@
"timezone": "",
"title": "GitHub_Release_Quality_and_Contribution_Analysis",
"uid": "2xuOaQUnk4",
- "version": 21
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/Gitlab.json b/grafana/dashboards/Gitlab.json
index b0f084126..fc6162128 100644
--- a/grafana/dashboards/Gitlab.json
+++ b/grafana/dashboards/Gitlab.json
@@ -16,7 +16,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": 26,
- "iteration": 1677590524546,
+ "iteration": 1682063010710,
"links": [],
"panels": [
{
@@ -306,7 +306,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n author_name,\n\tcount(*) as
merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n
$__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand pr.status
in ('closed', 'merged') and pr.merged_date is not null\ngroup by 1\norder by 2
desc\nlimit 20\n",
+ "rawSql": "select\n author_name,\n\tcount(*) as
merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n
$__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand pr.status
in ('CLOSED', 'MERGED') and pr.merged_date is not null\ngroup by 1\norder by 2
desc\nlimit 20\n",
"refId": "A",
"select": [
[
@@ -401,7 +401,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n count(distinct case when status in ('closed',
'merged') and merged_date is null then id else null end)/count(distinct case
when status in ('closed', 'merged') then id else null end) as ratio\nfrom
\n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id
in ($repo_id)",
+ "rawSql": "select\n count(distinct case when status in ('CLOSED',
'MERGED') and merged_date is null then id else null end)/count(distinct case
when status in ('CLOSED', 'MERGED') then id else null end) as ratio\nfrom
\n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id
in ($repo_id)",
"refId": "A",
"select": [
[
@@ -504,7 +504,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL
-DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when
status not in ('closed','merged') then id else null end) as \"PR: Open\",\n
count(distinct case when status in ('closed', 'merged') and merged_date is null
then id else null end) as \"PR: Closed without merging\",\n count(distinct
case when status in ('closed', 'merged') and merged_date is not null then id
else null end) as \"PR: Merged\"\nFRO [...]
+ "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL
-DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when
status not in ('CLOSED', 'MERGED') then id else null end) as \"PR: Open\",\n
count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is null
then id else null end) as \"PR: Closed without merging\",\n count(distinct
case when status in ('CLOSED', 'MERGED') and merged_date is not null then id
else null end) as \"PR: Merged\"\nFR [...]
"refId": "A",
"select": [
[
@@ -586,7 +586,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom
\n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id
in ($repo_id)\n\tand pr.status in ('closed', 'merged') and pr.merged_date is
null",
+ "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom
\n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id
in ($repo_id)\n\tand pr.status in ('CLOSED', 'MERGED') and pr.merged_date is
null",
"refId": "A",
"select": [
[
@@ -693,7 +693,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL
-DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when
status in ('closed', 'merged') and merged_date is null then id else null
end)/count(distinct case when status in ('closed', 'merged') and merged_date is
not null then id else null end) as ratio\nFROM pull_requests\nWHERE\n
$__timeFilter(created_date)\n and base_repo_id in ($repo_id)\ngroup by 1\n",
+ "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL
-DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when
status in ('CLOSED', 'MERGED') and merged_date is null then id else null
end)/count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is
not null then id else null end) as ratio\nFROM pull_requests\nWHERE\n
$__timeFilter(created_date)\n and base_repo_id in ($repo_id)\ngroup by 1\n",
"refId": "A",
"select": [
[
@@ -952,7 +952,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql":
"select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as
time_to_close\nfrom \n\tpull_requests\nwhere \n
$__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand status in
('closed', 'merged')\n\n\n",
+ "rawSql":
"select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as
time_to_close\nfrom \n\tpull_requests\nwhere \n
$__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand status in
('CLOSED', 'MERGED')\n\n\n",
"refId": "A",
"select": [
[
@@ -1049,7 +1049,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "with _prs as(\n SELECT\n DATE_ADD(date(created_date),
INTERVAL -DAY(date(created_date))+1 DAY) as time,\n
avg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\n
FROM pull_requests\n WHERE\n $__timeFilter(created_date)\n and
base_repo_id in ($repo_id)\n and status in ('closed', 'merged')\n and
created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1
DAY), INTERVAL +1 MONTH)\n group by 1\n)\n\nSELECT \n [...]
+ "rawSql": "with _prs as(\n SELECT\n DATE_ADD(date(created_date),
INTERVAL -DAY(date(created_date))+1 DAY) as time,\n
avg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\n
FROM pull_requests\n WHERE\n $__timeFilter(created_date)\n and
base_repo_id in ($repo_id)\n and status in ('CLOSED', 'MERGED')\n and
created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1
DAY), INTERVAL +1 MONTH)\n group by 1\n)\n\nSELECT \n [...]
"refId": "A",
"select": [
[
@@ -1143,5 +1143,5 @@
"timezone": "",
"title": "GitLab",
"uid": "msSjEq97z",
- "version": 10
+ "version": 11
}
\ No newline at end of file
diff --git a/grafana/dashboards/Jenkins.json b/grafana/dashboards/Jenkins.json
index ac153ee4f..fc72fe2c3 100644
--- a/grafana/dashboards/Jenkins.json
+++ b/grafana/dashboards/Jenkins.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 33,
- "iteration": 1678171137345,
+ "id": 4,
+ "iteration": 1682063024677,
"links": [],
"panels": [
{
@@ -971,5 +971,5 @@
"timezone": "",
"title": "Jenkins",
"uid": "W8AiDFQnk",
- "version": 10
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/Jira.json b/grafana/dashboards/Jira.json
index 3b703ce8c..ed53692a9 100644
--- a/grafana/dashboards/Jira.json
+++ b/grafana/dashboards/Jira.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 20,
- "iteration": 1672983005672,
+ "id": 14,
+ "iteration": 1682063040196,
"links": [
{
"asDropdown": false,
@@ -1027,5 +1027,5 @@
"timezone": "",
"title": "Jira",
"uid": "F5vqBQl7z",
- "version": 2
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/Sonarqube.json
b/grafana/dashboards/Sonarqube.json
index 66ebd3f44..f411f64a6 100644
--- a/grafana/dashboards/Sonarqube.json
+++ b/grafana/dashboards/Sonarqube.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 2,
- "iteration": 1678275507113,
+ "id": 29,
+ "iteration": 1682063057579,
"links": [],
"panels": [
{
@@ -927,7 +927,7 @@
{
"allValue": null,
"current": {
- "selected": false,
+ "selected": true,
"text": [
"All"
],
@@ -955,7 +955,7 @@
{
"allValue": null,
"current": {
- "selected": false,
+ "selected": true,
"text": [
"All"
],
@@ -983,7 +983,7 @@
{
"allValue": null,
"current": {
- "selected": false,
+ "selected": true,
"text": [
"All"
],
@@ -1054,5 +1054,5 @@
"timezone": "",
"title": "SonarQube",
"uid": "WA0qbuJ4k",
- "version": 5
+ "version": 1
}
\ No newline at end of file
diff --git a/grafana/dashboards/TAPD.json b/grafana/dashboards/TAPD.json
index f45c396dd..cef23ebb7 100644
--- a/grafana/dashboards/TAPD.json
+++ b/grafana/dashboards/TAPD.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 22,
- "iteration": 1672982963558,
+ "id": 16,
+ "iteration": 1682063068647,
"links": [
{
"asDropdown": false,
diff --git a/grafana/dashboards/WeeklyBugRetro.json
b/grafana/dashboards/WeeklyBugRetro.json
index 236cdcffc..7e33ce822 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -1595,8 +1595,8 @@
"allValue": null,
"current": {
"selected": false,
- "text": "apache/incubator-devlake",
- "value": "github:GithubRepo:1:384111310"
+ "text": "All",
+ "value": "$__all"
},
"datasource": "mysql",
"definition": "select concat(name, '-', id) as text from boards",
diff --git a/grafana/dashboards/WeeklyCommunityRetro.json
b/grafana/dashboards/WeeklyCommunityRetro.json
index 175700918..d219c91f3 100644
--- a/grafana/dashboards/WeeklyCommunityRetro.json
+++ b/grafana/dashboards/WeeklyCommunityRetro.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 9,
- "iteration": 1660821905109,
+ "id": 27,
+ "iteration": 1682063086384,
"links": [],
"panels": [
{
@@ -1790,5 +1790,5 @@
"timezone": "",
"title": "Weekly Community Retro",
"uid": "VTr6Y_q7z",
- "version": 7
+ "version": 3
}
\ No newline at end of file
