You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by kl...@apache.org on 2022/06/22 15:33:30 UTC
[incubator-devlake] branch main updated: feat: update weekly bug retro dashboard (#2324)
This is an automated email from the ASF dual-hosted git repository.
klesh 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 60ad39a9 feat: update weekly bug retro dashboard (#2324)
60ad39a9 is described below
commit 60ad39a964c333113d314b798efc635f96b86fea
Author: Louis.z <lo...@gmail.com>
AuthorDate: Wed Jun 22 23:33:27 2022 +0800
feat: update weekly bug retro dashboard (#2324)
* feat: update weekly bug retro dashboard
* fix: update wording for panel outstanding bugs
Co-authored-by: Startrekzky <ka...@merico.dev>
---
grafana/dashboards/WeeklyBugRetro.json | 509 ++++++++++++++++++++++++++++++---
1 file changed, 477 insertions(+), 32 deletions(-)
diff --git a/grafana/dashboards/WeeklyBugRetro.json b/grafana/dashboards/WeeklyBugRetro.json
index e57213a7..72f57c7f 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 10,
- "iteration": 1650781337006,
+ "id": 5,
+ "iteration": 1655906148389,
"links": [],
"panels": [
{
@@ -45,7 +45,7 @@
},
"gridPos": {
"h": 8,
- "w": 12,
+ "w": 6,
"x": 0,
"y": 0
},
@@ -73,7 +73,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(*)\nfrom\n lake.issues as i\n join lake.board_issues bi on i.id = bi.issue_id\n join boards b on bi.board_id = b.id\nwhere\n type = 'BUG' \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 count(*)\nfrom\n lake.issues as i\n join lake.board_issues bi on i.id = bi.issue_id\n join 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": [
[
@@ -100,6 +100,89 @@
"title": "Previous Week New Bug Count",
"type": "stat"
},
+ {
+ "datasource": "mysql",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ }
+ },
+ "mappings": []
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 8,
+ "w": 6,
+ "x": 6,
+ "y": 0
+ },
+ "id": 26,
+ "options": {
+ "displayLabels": [
+ "name",
+ "value"
+ ],
+ "legend": {
+ "displayMode": "list",
+ "placement": "bottom",
+ "values": [
+ "percent",
+ "value"
+ ]
+ },
+ "pieType": "donut",
+ "reduceOptions": {
+ "calcs": [],
+ "fields": "",
+ "values": true
+ },
+ "tooltip": {
+ "mode": "multi"
+ }
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "metricColumn": "none",
+ "queryType": "randomWalk",
+ "rawQuery": true,
+ "rawSql": "select\n case when component != '' then component else 'Issue-without-component' end as component,\n count(*) as 'Issue Number'\nfrom\n lake.issues as i\n join lake.board_issues bi on i.id = bi.issue_id\n join 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)\ngroup by 1",
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "script_version"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "_devlake_migration_history",
+ "timeColumn": "created_at",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "Previous Week New Bug Count by Components",
+ "type": "piechart"
+ },
{
"datasource": "mysql",
"fieldConfig": {
@@ -158,7 +241,7 @@
"properties": [
{
"id": "custom.width",
- "value": 508
+ "value": 753
}
]
},
@@ -179,6 +262,30 @@
]
}
]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "Issue Number"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 124
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "Title"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 640
+ }
+ ]
}
]
},
@@ -201,7 +308,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.issue_key,\n i.title,\n i.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 = 'BUG' \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.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)",
"refId": "A",
"select": [
[
@@ -282,7 +389,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(*)\nfrom\n lake.issues as i\n join board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n type = 'BUG'\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 count(*)\nfrom\n lake.issues as i\n join 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": [
[
@@ -306,7 +413,7 @@
]
}
],
- "title": "Previous Week Fixed Bugs Count",
+ "title": "Last Week's Fixed Bugs Count",
"type": "stat"
},
{
@@ -325,9 +432,13 @@
"color": "green",
"value": null
},
+ {
+ "color": "yellow",
+ "value": 14
+ },
{
"color": "red",
- "value": 80
+ "value": 21
}
]
}
@@ -340,7 +451,7 @@
"x": 6,
"y": 8
},
- "id": 12,
+ "id": 24,
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -364,7 +475,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n avg(lead_time_minutes / 1440)\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 = 'BUG'\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 avg(lead_time_minutes / 1440)\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": [
[
@@ -456,14 +567,38 @@
"properties": [
{
"id": "custom.width",
- "value": 514
+ "value": 754
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "Issue Number"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 125
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "Title"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 639
}
]
}
]
},
"gridPos": {
- "h": 8,
+ "h": 16,
"w": 12,
"x": 12,
"y": 8
@@ -481,7 +616,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.issue_key,\n i.title,\n i.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 = 'BUG'\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.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)",
"refId": "A",
"select": [
[
@@ -508,6 +643,103 @@
"title": "Last Week's Fixed Bugs",
"type": "table"
},
+ {
+ "datasource": "mysql",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "axisSoftMin": 0,
+ "fillOpacity": 80,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineWidth": 1
+ },
+ "decimals": 1,
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 8,
+ "w": 12,
+ "x": 0,
+ "y": 16
+ },
+ "id": 23,
+ "options": {
+ "barWidth": 0.3,
+ "groupWidth": 0.7,
+ "legend": {
+ "calcs": [
+ "mean"
+ ],
+ "displayMode": "list",
+ "placement": "bottom"
+ },
+ "orientation": "horizontal",
+ "showValue": "auto",
+ "text": {},
+ "tooltip": {
+ "mode": "single"
+ }
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "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",
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "script_version"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "_devlake_migration_history",
+ "timeColumn": "created_at",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "Lead Time Distribution [Last Week's Resolved Bugs in Days]",
+ "type": "barchart"
+ },
{
"datasource": "mysql",
"fieldConfig": {
@@ -536,7 +768,7 @@
"h": 9,
"w": 6,
"x": 0,
- "y": 16
+ "y": 24
},
"id": 16,
"options": {
@@ -562,7 +794,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(*)\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 = 'BUG'\n and i.status != 'DONE'\n and b.id in ($repo_id)",
+ "rawSql": "select\n count(*)\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)",
"refId": "A",
"select": [
[
@@ -606,7 +838,7 @@
},
{
"color": "red",
- "value": 80
+ "value": 30
}
]
}
@@ -617,9 +849,9 @@
"h": 9,
"w": 6,
"x": 6,
- "y": 16
+ "y": 24
},
- "id": 18,
+ "id": 25,
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -643,7 +875,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n avg((TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440)\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 = 'BUG'\n and i.status != 'DONE'\n and b.id in ($repo_id)",
+ "rawSql": "select \n avg((TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440)\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)",
"refId": "A",
"select": [
[
@@ -717,7 +949,7 @@
"properties": [
{
"id": "custom.width",
- "value": 116
+ "value": 121
}
]
},
@@ -753,7 +985,7 @@
"properties": [
{
"id": "custom.width",
- "value": 213
+ "value": 152
}
]
},
@@ -790,10 +1022,10 @@
]
},
"gridPos": {
- "h": 9,
+ "h": 18,
"w": 12,
"x": 12,
- "y": 16
+ "y": 24
},
"id": 14,
"options": {
@@ -808,7 +1040,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "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\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 = 'BUG'\n and i.status != 'DONE'\n and b.id in ($repo_id)\norder by 'Queue Time' desc",
+ "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",
"refId": "A",
"select": [
[
@@ -832,9 +1064,105 @@
]
}
],
- "title": "Outstanding Bugs by Age",
+ "title": "Outstanding Bugs Sort by Queue Time [All History]",
"type": "table"
},
+ {
+ "datasource": "mysql",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "axisSoftMin": 0,
+ "fillOpacity": 80,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineWidth": 1
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 9,
+ "w": 12,
+ "x": 0,
+ "y": 33
+ },
+ "id": 18,
+ "options": {
+ "barWidth": 0.5,
+ "groupWidth": 0.7,
+ "legend": {
+ "calcs": [
+ "mean"
+ ],
+ "displayMode": "list",
+ "placement": "bottom"
+ },
+ "orientation": "auto",
+ "showValue": "auto",
+ "text": {},
+ "tooltip": {
+ "mode": "single"
+ }
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "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",
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "script_version"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "_devlake_migration_history",
+ "timeColumn": "created_at",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "Distribution of Bug Queue Time in Days [Outstanding Bugs]",
+ "type": "barchart"
+ },
{
"datasource": "mysql",
"fieldConfig": {
@@ -876,7 +1204,7 @@
"h": 9,
"w": 24,
"x": 0,
- "y": 25
+ "y": 42
},
"id": 2,
"options": {
@@ -901,7 +1229,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with bugs as ( \n select \n DATE_ADD(date(i.created_date), INTERVAL -WEEKDAY(date(i.created_date)) DAY) as time,\n count(*) as bug_count\n from\n lake.issues as i\n\t join lake.board_issues bi on i.id = bi.issue_id\n\t join lake.boards b on bi.board_id = b.id\n where \n type = 'Bug'\n and $__timeFilter(i.created_date)\n and b.id in ($repo_id)\n group by time\n order by time desc\n)\n\nselect\n date_format(time,'%m/%d') as week,\n bug_count [...]
+ "rawSql": "with bugs as ( \n select \n DATE_ADD(date(i.created_date), INTERVAL -WEEKDAY(date(i.created_date)) DAY) as time,\n count(*) as bug_count\n from\n lake.issues as i\n\t join lake.board_issues bi on i.id = bi.issue_id\n\t join lake.boards b on bi.board_id = b.id\n where \n type in ($issue_type)\n and $__timeFilter(i.created_date)\n and b.id in ($repo_id)\n group by time\n order by time desc\n),\n\ncalendar_date as(\n\tSELECT CAST((SYSDATE()-INT [...]
"refId": "A",
"select": [
[
@@ -969,7 +1297,7 @@
"h": 10,
"w": 24,
"x": 0,
- "y": 34
+ "y": 51
},
"id": 20,
"options": {
@@ -994,7 +1322,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with bugs as (\n select \n DATE_ADD(date(i.resolution_date), INTERVAL -WEEKDAY(date(i.resolution_date)) DAY) as time,\n count(*) as bug_count\n from\n lake.issues as i\n\t join lake.board_issues bi on i.id = bi.issue_id\n\t join lake.boards b on bi.board_id = b.id\n where \n type = 'Bug'\n and status = 'DONE'\n and $__timeFilter(i.resolution_date)\n and b.id in ($repo_id)\n group by time\n order by time desc\n)\n\nselect\n date_format(tim [...]
+ "rawSql": "with bugs as (\n select \n DATE_ADD(date(i.resolution_date), INTERVAL -WEEKDAY(date(i.resolution_date)) DAY) as time,\n count(*) as bug_count\n from\n lake.issues as i\n\t join lake.board_issues bi on i.id = bi.issue_id\n\t join lake.boards b on bi.board_id = b.id\n where \n type in ($issue_type)\n and status = 'DONE'\n and $__timeFilter(i.resolution_date)\n and b.id in ($repo_id)\n group by time\n order by time desc\n),\n\ncalendar_date a [...]
"refId": "A",
"select": [
[
@@ -1020,6 +1348,99 @@
],
"title": "Weekly Closed Bugs [Selected Time Range]",
"type": "barchart"
+ },
+ {
+ "datasource": "mysql",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "axisSoftMin": 0,
+ "fillOpacity": 46,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineWidth": 1
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 10,
+ "w": 24,
+ "x": 0,
+ "y": 61
+ },
+ "id": 21,
+ "options": {
+ "barWidth": 0.71,
+ "groupWidth": 0.7,
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
+ },
+ "orientation": "auto",
+ "showValue": "auto",
+ "text": {},
+ "tooltip": {
+ "mode": "single"
+ }
+ },
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "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 [...]
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "script_version"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "_devlake_migration_history",
+ "timeColumn": "created_at",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "Total Outstanding Bug Count by Week [Selected Time Range]",
+ "type": "barchart"
}
],
"schemaVersion": 30,
@@ -1031,7 +1452,7 @@
"allValue": null,
"current": {
"selected": false,
- "text": "merico-dev/lake",
+ "text": "apache/incubator-devlake",
"value": "github:GithubRepo:384111310"
},
"datasource": "mysql",
@@ -1050,6 +1471,30 @@
"skipUrlSync": false,
"sort": 0,
"type": "query"
+ },
+ {
+ "allValue": null,
+ "current": {
+ "selected": false,
+ "text": "BUG",
+ "value": "BUG"
+ },
+ "datasource": "mysql",
+ "definition": "select distinct type from issues",
+ "description": null,
+ "error": null,
+ "hide": 0,
+ "includeAll": true,
+ "label": "Issue Type",
+ "multi": false,
+ "name": "issue_type",
+ "options": [],
+ "query": "select distinct type from issues",
+ "refresh": 1,
+ "regex": "",
+ "skipUrlSync": false,
+ "sort": 0,
+ "type": "query"
}
]
},
@@ -1061,5 +1506,5 @@
"timezone": "",
"title": "Weekly Bug Retro",
"uid": "-5EKA5w7k",
- "version": 8
+ "version": 29
}
\ No newline at end of file