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 8a9a05f1 fix: update dashboards according to schema changes
8a9a05f1 is described below
commit 8a9a05f1c9b1e2248ea55bb3d97bd54878048c96
Author: Startrekzky <[email protected]>
AuthorDate: Mon Jul 25 15:40:01 2022 +0800
fix: update dashboards according to schema changes
---
grafana/dashboards/EngineeringOverview.json | 56 ++--
...ithubReleaseQualityAndContributionAnalysis.json | 337 ++++++---------------
grafana/dashboards/WeeklyBugRetro.json | 38 ++-
3 files changed, 136 insertions(+), 295 deletions(-)
diff --git a/grafana/dashboards/EngineeringOverview.json
b/grafana/dashboards/EngineeringOverview.json
index e478da18..21bb562c 100644
--- a/grafana/dashboards/EngineeringOverview.json
+++ b/grafana/dashboards/EngineeringOverview.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 13,
- "iteration": 1653390976868,
+ "id": 12,
+ "iteration": 1658734029836,
"links": [],
"panels": [
{
@@ -256,7 +256,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _inprogress_times as (\n select\n i.id as
issue_id,\n c.created_date as inprogress_time\n from\n lake.issues i\n
join lake.changelogs c on i.id = c.issue_id\n where\n c.field_name =
'status'\n and c.to in ($inprogress_status) \n and date(i.created_date)
between STR_TO_DATE('$month','%Y-%m-%d') and STR_TO_DATE('$month','%Y-%m-%d') +
INTERVAL 1 MONTH - INTERVAL 1 DAY\n),\n\n_done_times as (\n select\n i.id
as issue_id,\n c.created_da [...]
+ "rawSql": "with _inprogress_times as (\n select\n i.id as
issue_id,\n c.created_date as inprogress_time\n from\n lake.issues i\n
join lake.issue_changelogs c on i.id = c.issue_id\n where\n c.field_name =
'status'\n and c.original_to_value in ($inprogress_status) \n and
date(i.created_date) between STR_TO_DATE('$month','%Y-%m-%d') and
STR_TO_DATE('$month','%Y-%m-%d') + INTERVAL 1 MONTH - INTERVAL 1
DAY\n),\n\n_done_times as (\n select\n i.id as issue_ [...]
"refId": "A",
"select": [
[
@@ -365,7 +365,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _inprogress_times as (\n select\n i.id as
issue_id,\n i.created_date,\n c.created_date as inprogress_time\n from\n
lake.issues i\n join lake.changelogs c on i.id = c.issue_id\n where\n
c.field_name = 'status'\n and c.to in ($inprogress_status) \n and
$__timeFilter(i.created_date)\n and i.created_date >=
DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL
+1 MONTH)\n),\n\n_done_times as (\n select\n i.i [...]
+ "rawSql": "with _inprogress_times as (\n select\n i.id as
issue_id,\n i.created_date,\n c.created_date as inprogress_time\n from\n
lake.issues i\n join lake.issue_changelogs c on i.id = c.issue_id\n
where\n c.field_name = 'status'\n and c.original_to_value in
($inprogress_status) \n and $__timeFilter(i.created_date)\n and
i.created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL
-DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)\n),\n\n_done_times as [...]
"refId": "A",
"select": [
[
@@ -408,7 +408,7 @@
"value": null
},
{
- "color": "orange",
+ "color": "yellow",
"value": 10
},
{
@@ -633,7 +633,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _num_issues_with_sprint_updated as (\n select\n
count(*) as num_issues_with_sprint_updated\n from\n lake.issues i\n join
lake.changelogs c on i.id = c.issue_id\n where\n c.field_name = 'Sprint'
and\n c.from != '' and\n c.to != '' and\n date(i.created_date)
between\n STR_TO_DATE('$month','%Y-%m-%d') and\n
STR_TO_DATE('$month','%Y-%m-%d') + INTERVAL 1 MONTH - INTERVAL 1
DAY\n),\n\n_total_num_issues as (\n select\n count(*) as [...]
+ "rawSql": "with _num_issues_with_sprint_updated as (\n select\n
count(*) as num_issues_with_sprint_updated\n from\n lake.issues i\n join
lake.issue_changelogs c on i.id = c.issue_id\n where\n c.field_name =
'Sprint' and\n c.original_from_value != '' and\n c.original_to_value !=
'' and\n date(i.created_date) between\n
STR_TO_DATE('$month','%Y-%m-%d') and\n STR_TO_DATE('$month','%Y-%m-%d') +
INTERVAL 1 MONTH - INTERVAL 1 DAY\n),\n\n_total_num_iss [...]
"refId": "A",
"select": [
[
@@ -739,7 +739,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _num_issues_with_sprint_updated as (\n select\n
DATE_ADD(date(i.created_date), INTERVAL -DAY(date(i.created_date))+1 DAY) as
time,\n count(*) as num_issues_with_sprint_updated\n from\n lake.issues
i\n join lake.changelogs c on i.id = c.issue_id\n where\n c.field_name =
'Sprint'\n and c.from != '' \n and c.to != ''\n and
$__timeFilter(i.created_date)\n and i.created_date >=
DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom() [...]
+ "rawSql": "with _num_issues_with_sprint_updated as (\n select\n
DATE_ADD(date(i.created_date), INTERVAL -DAY(date(i.created_date))+1 DAY) as
time,\n count(*) as num_issues_with_sprint_updated\n from\n lake.issues
i\n join lake.issue_changelogs c on i.id = c.issue_id\n where\n
c.field_name = 'Sprint'\n and c.original_from_value != '' \n and
c.original_to_value != ''\n and $__timeFilter(i.created_date)\n and
i.created_date >= DATE_ADD(DATE_ADD($__tim [...]
"refId": "A",
"select": [
[
@@ -821,7 +821,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(*)\nfrom\n lake.pull_requests
pr\nwhere\n pr.merged_date is not null and\n date(pr.merged_date) between\n
STR_TO_DATE('$month','%Y-%m-%d') and\n STR_TO_DATE('$month','%Y-%m-%d') +
INTERVAL 1 MONTH - INTERVAL 1 DAY and\n pr.base_repo_id in ($repo_id);",
+ "rawSql": "select\n count(*)\nfrom\n lake.pull_requests
pr\nwhere\n pr.merged_date is not null \n and date(pr.merged_date) between\n
STR_TO_DATE('$month','%Y-%m-%d')\n and STR_TO_DATE('$month','%Y-%m-%d') +
INTERVAL 1 MONTH - INTERVAL 1 DAY \n and pr.base_repo_id in ($repo_id);",
"refId": "A",
"select": [
[
@@ -1380,7 +1380,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n AVG(TIMESTAMPDIFF(MINUTE, pr.created_date,
pr.merged_date) / 1440)\nfrom\n lake.pull_requests pr\nwhere\n pr.merged_date
is not null\n and pr.base_repo_id in ($repo_id)\n and date(pr.created_date)
between\n STR_TO_DATE('$month','%Y-%m-%d') and\n
STR_TO_DATE('$month','%Y-%m-%d') + INTERVAL 1 MONTH - INTERVAL 1 DAY",
+ "rawSql": "select\n AVG(TIMESTAMPDIFF(MINUTE, pr.created_date,
pr.merged_date) / 1440)\nfrom\n lake.pull_requests pr\nwhere\n pr.merged_date
is not null\n and pr.base_repo_id in ($repo_id)\n and date(pr.created_date)
between\n STR_TO_DATE('$month','%Y-%m-%d') \n and
STR_TO_DATE('$month','%Y-%m-%d') + INTERVAL 1 MONTH - INTERVAL 1 DAY",
"refId": "A",
"select": [
[
@@ -1729,8 +1729,8 @@
"allValue": null,
"current": {
"selected": true,
- "text": "2022-03",
- "value": "2022-03-01"
+ "text": "2022-06",
+ "value": "2022-06-01"
},
"datasource": "mysql",
"definition": "select\n
distinct(concat(date_format(DATE_ADD(date(created_date), INTERVAL
-DAY(date(created_date))+1 DAY), '%Y-%m') , ':',
date_format(DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1
DAY), '%Y-%m-%d'))) as month\nfrom\n lake.issues i\norder by month desc",
@@ -1754,12 +1754,12 @@
"current": {
"selected": true,
"text": [
- "Highest",
- "High"
+ "High",
+ "Highest"
],
"value": [
- "Highest",
- "High"
+ "High",
+ "Highest"
]
},
"datasource": "mysql",
@@ -1784,18 +1784,14 @@
"current": {
"selected": true,
"text": [
- "In Progress",
- "处理中",
- "In Development"
+ "All"
],
"value": [
- "In Progress",
- "处理中",
- "In Development"
+ "$__all"
]
},
"datasource": "mysql",
- "definition": "select `to` from changelogs where field_name =
'status'",
+ "definition": "select original_to_value from issue_changelogs where
field_name = 'status'",
"description": "Customize status(es) that are considered as
\"In-Progress\"",
"error": null,
"hide": 0,
@@ -1804,7 +1800,7 @@
"multi": true,
"name": "inprogress_status",
"options": [],
- "query": "select `to` from changelogs where field_name = 'status'",
+ "query": "select original_to_value from issue_changelogs where
field_name = 'status'",
"refresh": 1,
"regex": "",
"skipUrlSync": false,
@@ -1816,18 +1812,14 @@
"current": {
"selected": true,
"text": [
- "Resolved",
- "已关闭",
- "已完成"
+ "All"
],
"value": [
- "Resolved",
- "已关闭",
- "已完成"
+ "$__all"
]
},
"datasource": "mysql",
- "definition": "select `to` from changelogs where field_name =
'status'",
+ "definition": "select original_to_value from issue_changelogs where
field_name = 'status'",
"description": "Customize status(es) that are considered as \"Done\"",
"error": null,
"hide": 0,
@@ -1836,7 +1828,7 @@
"multi": true,
"name": "done_status",
"options": [],
- "query": "select `to` from changelogs where field_name = 'status'",
+ "query": "select original_to_value from issue_changelogs where
field_name = 'status'",
"refresh": 1,
"regex": "",
"skipUrlSync": false,
@@ -1853,5 +1845,5 @@
"timezone": "",
"title": "Engineering Overview",
"uid": "ZF6abXX7z",
- "version": 46
+ "version": 1
}
\ No newline at end of file
diff --git
a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
index c12fcdfb..c9b28b7b 100644
--- a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
+++ b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
@@ -16,21 +16,9 @@
"gnetId": null,
"graphTooltip": 0,
"id": 15,
- "iteration": 1653992608241,
+ "iteration": 1658723594192,
"links": [],
"panels": [
- {
- "datasource": null,
- "gridPos": {
- "h": 1,
- "w": 24,
- "x": 0,
- "y": 0
- },
- "id": 49,
- "title": "Row title",
- "type": "row"
- },
{
"collapsed": false,
"datasource": null,
@@ -38,7 +26,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 1
+ "y": 0
},
"id": 45,
"panels": [],
@@ -69,7 +57,7 @@
"h": 7,
"w": 7,
"x": 0,
- "y": 2
+ "y": 1
},
"id": 15,
"options": {
@@ -101,10 +89,11 @@
{
"format": "table",
"group": [],
+ "hide": false,
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the bug distribution in major versions\nwith
bugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/tags/', -1) as tag_name,
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 3) as repo_id,\n\t\ti.issue_key,
i.type, i.title, i.description\n\tfrom\n\t\trefs_issues_diffs rid\n\t\tleft
join issues i on rid.issue_id =
i.id\n\twhere\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 3) in
($repo_id)\n\t\tand i.type = 'BUG'\n)\n\n\nSELECT \n\tconcat(SUBSTRING_INDEX
[...]
+ "rawSql": "-- Get the bug distribution in major versions\nwith
bugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/tags/', -1) as tag_name,
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 4) as repo_id,\n\t\ti.issue_key,
i.type, i.title, i.description\n\tfrom\n\t\trefs_issues_diffs rid\n\t\tleft
join issues i on rid.issue_id =
i.id\n\twhere\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 4) in
($repo_id)\n\t\tand i.type = 'BUG'\n)\n\n\nSELECT \n\tconcat(SUBSTRING_INDEX
[...]
"refId": "A",
"select": [
[
@@ -203,7 +192,7 @@
"h": 7,
"w": 17,
"x": 7,
- "y": 2
+ "y": 1
},
"id": 29,
"options": {
@@ -230,7 +219,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1)
as new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n --
distinct new_ref_id, old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name, \n\t\t- [...]
+ "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1)
as new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n --
distinct new_ref_id, old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name, \n\t\t- [...]
"refId": "A",
"select": [
[
@@ -274,83 +263,13 @@
},
"mappings": []
},
- "overrides": [
- {
- "__systemRef": "hideSeriesFrom",
- "matcher": {
- "id": "byNames",
- "options": {
- "mode": "exclude",
- "names": [
- "dev_eq"
- ],
- "prefix": "All except:",
- "readOnly": true
- }
- },
- "properties": [
- {
- "id": "custom.hideFrom",
- "value": {
- "legend": false,
- "tooltip": false,
- "viz": false
- }
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "v22.3.2.2-lts UNKNOWN"
- },
- "properties": [
- {
- "id": "color",
- "value": {
- "fixedColor": "blue",
- "mode": "fixed"
- }
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "v22.3.2.2-lts REQUIREMENT"
- },
- "properties": [
- {
- "id": "color",
- "value": {
- "fixedColor": "yellow",
- "mode": "fixed"
- }
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "v22.3.2.2-lts BUG"
- },
- "properties": [
- {
- "id": "color",
- "value": {
- "fixedColor": "green",
- "mode": "fixed"
- }
- }
- ]
- }
- ]
+ "overrides": []
},
"gridPos": {
"h": 7,
"w": 8,
"x": 0,
- "y": 9
+ "y": 8
},
"id": 55,
"options": {
@@ -385,7 +304,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX( [...]
+ "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX( [...]
"refId": "A",
"select": [
[
@@ -505,7 +424,7 @@
"h": 7,
"w": 8,
"x": 8,
- "y": 9
+ "y": 8
},
"id": 53,
"options": {
@@ -540,7 +459,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\nbugs_in_each_tag
as(\n\tselect \n\t\tSUBSTRING_INDE [...]
+ "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\nbugs_in_each_tag
as(\n\tselect \n\t\tSUBSTRING_INDE [...]
"refId": "A",
"select": [
[
@@ -584,83 +503,13 @@
},
"mappings": []
},
- "overrides": [
- {
- "__systemRef": "hideSeriesFrom",
- "matcher": {
- "id": "byNames",
- "options": {
- "mode": "exclude",
- "names": [
- "dev_eq"
- ],
- "prefix": "All except:",
- "readOnly": true
- }
- },
- "properties": [
- {
- "id": "custom.hideFrom",
- "value": {
- "legend": false,
- "tooltip": false,
- "viz": false
- }
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "v22.3.2.2-lts UNKNOWN"
- },
- "properties": [
- {
- "id": "color",
- "value": {
- "fixedColor": "blue",
- "mode": "fixed"
- }
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "v22.3.2.2-lts REQUIREMENT"
- },
- "properties": [
- {
- "id": "color",
- "value": {
- "fixedColor": "yellow",
- "mode": "fixed"
- }
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "v22.3.2.2-lts BUG"
- },
- "properties": [
- {
- "id": "color",
- "value": {
- "fixedColor": "green",
- "mode": "fixed"
- }
- }
- ]
- }
- ]
+ "overrides": []
},
"gridPos": {
"h": 7,
"w": 8,
"x": 16,
- "y": 9
+ "y": 8
},
"id": 51,
"options": {
@@ -695,7 +544,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\nbugs_in_each_tag
as(\n\tselect \n\t\tSUBSTRING_INDE [...]
+ "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\nbugs_in_each_tag
as(\n\tselect \n\t\tSUBSTRING_INDE [...]
"refId": "A",
"select": [
[
@@ -841,7 +690,7 @@
"h": 7,
"w": 24,
"x": 0,
- "y": 16
+ "y": 15
},
"id": 43,
"options": {
@@ -856,7 +705,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n)\n\t\nselect distinct\n\tb.name as
repo_name,\n\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_nam [...]
+ "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n)\n\t\nselect distinct\n\tb.name as
repo_name,\n\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_nam [...]
"refId": "A",
"select": [
[
@@ -907,7 +756,7 @@
"h": 7,
"w": 11,
"x": 0,
- "y": 23
+ "y": 22
},
"id": 30,
"options": {
@@ -942,7 +791,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Component distribution of bugs fixed in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/', -1) as tag_na [...]
+ "rawSql": "-- Component distribution of bugs fixed in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/', -1) as tag_na [...]
"refId": "A",
"select": [
[
@@ -993,7 +842,7 @@
"h": 7,
"w": 13,
"x": 11,
- "y": 23
+ "y": 22
},
"id": 31,
"options": {
@@ -1028,7 +877,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Component distribution of bugs fixed in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/', -1) as tag_na [...]
+ "rawSql": "-- Component distribution of bugs fixed in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/', -1) as tag_na [...]
"refId": "A",
"select": [
[
@@ -1089,7 +938,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 30
+ "y": 29
},
"id": 23,
"options": {
@@ -1115,7 +964,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the % of contributors who fixed 80% of bugs in the
last 5 tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
\n\t\ti.issue_key, i.type, i.severity, i.title, i.descripti [...]
+ "rawSql": "-- Get the % of contributors who fixed 80% of bugs in the
last 5 tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
\n\t\ti.issue_key, i.type, i.severity, i.title, i.descripti [...]
"refId": "A",
"select": [
[
@@ -1185,7 +1034,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 30
+ "y": 29
},
"id": 18,
"options": {
@@ -1212,7 +1061,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the bug fixer distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
\n\t\ti.issue_key, i.type, i.severity, i.title, i.description,\n\t\tpr.id, p
[...]
+ "rawSql": "-- Get the bug fixer distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
\n\t\ti.issue_key, i.type, i.severity, i.title, i.description,\n\t\tpr.id, p
[...]
"refId": "A",
"select": [
[
@@ -1269,7 +1118,7 @@
"h": 6,
"w": 4,
"x": 0,
- "y": 37
+ "y": 36
},
"id": 33,
"options": {
@@ -1365,7 +1214,7 @@
"h": 6,
"w": 20,
"x": 4,
- "y": 37
+ "y": 36
},
"id": 32,
"options": {
@@ -1392,7 +1241,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the bug age in the last 5 tags\nwith _last_5_tags
as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
distinct\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as
tag_name,\n\t\ti.id,\n\t\ti.lead_time_minutes\n\tfrom\n\t\trefs_issues [...]
+ "rawSql": "-- Get the bug age in the last 5 tags\nwith _last_5_tags
as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
distinct\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as
tag_name,\n\t\ti.id,\n\t\ti.lead_time_minutes\n\tfrom\n\t\trefs_issues [...]
"refId": "A",
"select": [
[
@@ -1449,7 +1298,7 @@
"h": 6,
"w": 4,
"x": 0,
- "y": 43
+ "y": 42
},
"id": 34,
"options": {
@@ -1621,7 +1470,7 @@
"h": 6,
"w": 20,
"x": 4,
- "y": 43
+ "y": 42
},
"id": 38,
"options": {
@@ -1636,7 +1485,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the bug fixer distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
distinct\n\t b.name,\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as ta
[...]
+ "rawSql": "-- Get the bug fixer distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
distinct\n\t b.name,\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as ta
[...]
"refId": "A",
"select": [
[
@@ -1742,7 +1591,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 49
+ "y": 48
},
"id": 35,
"options": {
@@ -1918,7 +1767,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 49
+ "y": 48
},
"id": 39,
"options": {
@@ -1967,7 +1816,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 55
+ "y": 54
},
"id": 47,
"panels": [],
@@ -2015,7 +1864,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 56
+ "y": 55
},
"id": 41,
"options": {
@@ -2041,7 +1890,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "-- Get the bug distribution in last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n)\n\nselect
\n\tSUBSTRING_INDEX(rcd.new_ref_id,'refs/tags/', -1) as
tag_name,\n\tSUBSTRING_INDEX(rcd.old_ref_id [...]
+ "rawSql": "-- Get the bug distribution in last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n)\n\nselect
\n\tSUBSTRING_INDEX(rcd.new_ref_id,'refs/tags/', -1) as
tag_name,\n\tSUBSTRING_INDEX(rcd.old_ref_id [...]
"refId": "A",
"select": [
[
@@ -2137,7 +1986,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 56
+ "y": 55
},
"id": 42,
"options": {
@@ -2151,7 +2000,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "-- Get the bug distribution in last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n)\n\nselect
\n\tSUBSTRING_INDEX(rcd.new_ref_id,'refs/tags/', -1) as
new_tag_name,\n\tSUBSTRING_INDEX(rcd.old_re [...]
+ "rawSql": "-- Get the bug distribution in last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n)\n\nselect
\n\tSUBSTRING_INDEX(rcd.new_ref_id,'refs/tags/', -1) as
new_tag_name,\n\tSUBSTRING_INDEX(rcd.old_re [...]
"refId": "A",
"select": [
[
@@ -2196,55 +2045,16 @@
"mappings": []
},
"overrides": [
- {
- "__systemRef": "hideSeriesFrom",
- "matcher": {
- "id": "byNames",
- "options": {
- "mode": "exclude",
- "names": [
- "dev_eq"
- ],
- "prefix": "All except:",
- "readOnly": true
- }
- },
- "properties": [
- {
- "id": "custom.hideFrom",
- "value": {
- "legend": false,
- "tooltip": false,
- "viz": false
- }
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "v22.3.2.2-lts UNKNOWN"
- },
- "properties": [
- {
- "id": "color",
- "value": {
- "fixedColor": "blue",
- "mode": "fixed"
- }
- }
- ]
- },
{
"matcher": {
"id": "byName",
- "options": "v22.3.2.2-lts REQUIREMENT"
+ "options": "v22.3.2.2-lts BUG"
},
"properties": [
{
"id": "color",
"value": {
- "fixedColor": "yellow",
+ "fixedColor": "red",
"mode": "fixed"
}
}
@@ -2253,13 +2063,13 @@
{
"matcher": {
"id": "byName",
- "options": "v22.3.2.2-lts BUG"
+ "options": "v22.3.2.2-lts UNKNOWN"
},
"properties": [
{
"id": "color",
"value": {
- "fixedColor": "green",
+ "fixedColor": "text",
"mode": "fixed"
}
}
@@ -2271,7 +2081,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 63
+ "y": 62
},
"id": 26,
"options": {
@@ -2306,7 +2116,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_request [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_request [...]
"refId": "A",
"select": [
[
@@ -2350,13 +2160,44 @@
},
"mappings": []
},
- "overrides": []
+ "overrides": [
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.2.3.5-stable UNKNOWN"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "text",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.2.3.5-stable BUG"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "red",
+ "mode": "fixed"
+ }
+ }
+ ]
+ }
+ ]
},
"gridPos": {
"h": 7,
"w": 8,
"x": 8,
- "y": 63
+ "y": 62
},
"id": 36,
"options": {
@@ -2391,7 +2232,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
"refId": "A",
"select": [
[
@@ -2439,13 +2280,13 @@
{
"matcher": {
"id": "byName",
- "options": "v22.1.4.30-stable BUG"
+ "options": "v22.1.4.30-stable UNKNOWN"
},
"properties": [
{
"id": "color",
"value": {
- "fixedColor": "dark-yellow",
+ "fixedColor": "text",
"mode": "fixed"
}
}
@@ -2454,13 +2295,13 @@
{
"matcher": {
"id": "byName",
- "options": "v22.1.4.30-stable REQUIREMENT"
+ "options": "v22.1.4.30-stable BUG"
},
"properties": [
{
"id": "color",
"value": {
- "fixedColor": "blue",
+ "fixedColor": "red",
"mode": "fixed"
}
}
@@ -2472,7 +2313,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 63
+ "y": 62
},
"id": 37,
"options": {
@@ -2507,7 +2348,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
"refId": "A",
"select": [
[
@@ -2568,7 +2409,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 70
+ "y": 69
},
"id": 27,
"options": {
@@ -2594,7 +2435,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get each contributor's work in bugfixing in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_author_commits as(\n SELECT
\n \tc.author_name,\n count(c.sha) as commit_count\n [...]
+ "rawSql": "-- Get each contributor's work in bugfixing in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_author_commits as(\n SELECT
\n \tc.author_name,\n count(c.sha) as commit_count\n [...]
"refId": "A",
"select": [
[
@@ -2663,7 +2504,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 70
+ "y": 69
},
"id": 3,
"options": {
@@ -2688,7 +2529,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _last_5_tags as(\n SELECT \n -- distinct
new_ref_id, old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as
new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n)\n\n\nSELECT \n\tc.author_name,\n
count(c.sha) total_dev_eq\nFROM \n refs_commits_diffs rcf\n left join commits
c on rcf.commit_sha = c.sha\nWHERE\n\t-- [...]
+ "rawSql": "with _last_5_tags as(\n SELECT \n -- distinct
new_ref_id, old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as
new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n)\n\n\nSELECT \n\tc.author_name,\n
count(c.sha) total_dev_eq\nFROM \n refs_commits_diffs rcf\n left join commits
c on rcf.commit_sha = c.sha\nWHERE\n\t-- [...]
"refId": "A",
"select": [
[
@@ -2760,5 +2601,5 @@
"timezone": "",
"title": "GitHub_Release_Quality_and_Contribution_Analysis",
"uid": "2xuOaQUnk4",
- "version": 4
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/WeeklyBugRetro.json
b/grafana/dashboards/WeeklyBugRetro.json
index 72f57c7f..e6940ed8 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 5,
- "iteration": 1655906148389,
+ "id": 8,
+ "iteration": 1658722995471,
"links": [],
"panels": [
{
@@ -308,7 +308,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.number as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url'\nfrom\n lake.issues as i\n\tjoin lake.board_issues
bi on i.id = bi.issue_id\n\tjoin lake.boards b on bi.board_id = b.id\nwhere\n
type in ($issue_type)\n and date(i.created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n
and b.id in ($repo_id)",
+ "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url'\nfrom\n lake.issues as i\n\tjoin lake.board_issues
bi on i.id = bi.issue_id\n\tjoin lake.boards b on bi.board_id = b.id\nwhere\n
type in ($issue_type)\n and date(i.created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n
and b.id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -616,7 +616,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.number as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url'\nfrom\n lake.issues as i\n\tjoin board_issues bi on
i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n type in
($issue_type)\n and status = 'DONE'\n and date(i.resolution_date) BETWEEN
curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL
WEEKDAY(curdate())+1 DAY\n and b.id in ($repo_id)",
+ "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url'\nfrom\n lake.issues as i\n\tjoin board_issues bi on
i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n type in
($issue_type)\n and status = 'DONE'\n and date(i.resolution_date) BETWEEN
curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL
WEEKDAY(curdate())+1 DAY\n and b.id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -713,7 +713,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n concat('#',i.title) as issue_key,\n
lead_time_minutes/1440 as lead_time\nfrom\n lake.issues as i\n\tjoin
board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id =
b.id\nwhere\n type in ($issue_type)\n and status = 'DONE'\n and
date(i.resolution_date) BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY
AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n and b.id in
($repo_id)\norder by lead_time desc",
+ "rawSql": "select\n concat('#',i.issue_key, ' ', i.title) as
issue_key,\n lead_time_minutes/1440 as lead_time\nfrom\n lake.issues as
i\n\tjoin board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id
= b.id\nwhere\n type in ($issue_type)\n and status = 'DONE'\n and
date(i.resolution_date) BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY
AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n and b.id in
($repo_id)\norder by lead_time desc",
"refId": "A",
"select": [
[
@@ -1040,7 +1040,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n i.number as 'Issue Number',\n i.title as
'Title',\n (TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time
in Days',\n i.url as 'Url'\nfrom \n lake.issues i\n\tjoin board_issues bi on
i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n i.type in
($issue_type)\n and i.status != 'DONE'\n and b.id in ($repo_id)\norder by
'Queue Time' desc",
+ "rawSql": "select \n i.issue_key as 'Issue Number',\n i.title as
'Title',\n (TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time
in Days',\n i.url as 'Url'\nfrom \n lake.issues i\n\tjoin board_issues bi on
i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n i.type in
($issue_type)\n and i.status != 'DONE'\n and b.id in ($repo_id)\norder by
'Queue Time' desc",
"refId": "A",
"select": [
[
@@ -1136,7 +1136,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n concat('#', i.number) as issue_key,\n
(TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time in
Days'\nfrom \n lake.issues i\n\tjoin board_issues bi on i.id =
bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n type in
($issue_type)\n and i.status != 'DONE'\n and b.id in ($repo_id)\norder by 2
desc",
+ "rawSql": "select \n concat('#', i.issue_key, ' ', i.title) as
issue_key,\n (TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time
in Days'\nfrom \n lake.issues i\n\tjoin board_issues bi on i.id =
bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n type in
($issue_type)\n and i.status != 'DONE'\n and b.id in ($repo_id)\norder by 2
desc",
"refId": "A",
"select": [
[
@@ -1217,7 +1217,9 @@
},
"orientation": "auto",
"showValue": "auto",
- "text": {},
+ "text": {
+ "valueSize": 12
+ },
"tooltip": {
"mode": "single"
}
@@ -1310,7 +1312,9 @@
},
"orientation": "auto",
"showValue": "auto",
- "text": {},
+ "text": {
+ "valueSize": 12
+ },
"tooltip": {
"mode": "single"
}
@@ -1397,13 +1401,17 @@
"barWidth": 0.71,
"groupWidth": 0.7,
"legend": {
- "calcs": [],
+ "calcs": [
+ "mean"
+ ],
"displayMode": "list",
"placement": "bottom"
},
"orientation": "auto",
"showValue": "auto",
- "text": {},
+ "text": {
+ "valueSize": 12
+ },
"tooltip": {
"mode": "single"
}
@@ -1415,7 +1423,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with calendar_date as(\n\tSELECT CAST((SYSDATE()-INTERVAL
(H+T+U) DAY) AS date) d\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 SELECT
60\n\t\t\tUNION ALL SELECT 70 UNION ALL SELECT 80 UNION ALL SELECT 90\n\t\t)
T CROSS JOIN ( SELECT 0 U\n\t\t\tUNION ALL SELEC [...]
+ "rawSql": "with calendar_date as(\n\tSELECT CAST((SYSDATE()-INTERVAL
(H+T+U) DAY) AS date) d\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 SELECT
60\n\t\t\tUNION ALL SELECT 70 UNION ALL SELECT 80 UNION ALL SELECT 90\n\t\t)
T CROSS JOIN ( SELECT 0 U\n\t\t\tUNION ALL SELEC [...]
"refId": "A",
"select": [
[
@@ -1452,8 +1460,8 @@
"allValue": null,
"current": {
"selected": false,
- "text": "apache/incubator-devlake",
- "value": "github:GithubRepo:384111310"
+ "text": "All",
+ "value": "$__all"
},
"datasource": "mysql",
"definition": "select concat(name, '-', id) as text from repos",
@@ -1506,5 +1514,5 @@
"timezone": "",
"title": "Weekly Bug Retro",
"uid": "-5EKA5w7k",
- "version": 29
+ "version": 3
}
\ No newline at end of file
