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 8938b9e0a chore(grafana): exclude rejected bugs from weekly retro
(#8606)
8938b9e0a is described below
commit 8938b9e0a15aad5dc2a9ca491ead3c575757798a
Author: Kostas Petrakis <[email protected]>
AuthorDate: Fri Oct 10 14:28:55 2025 +0200
chore(grafana): exclude rejected bugs from weekly retro (#8606)
Co-authored-by: Kostas Petrakis <[email protected]>
---
grafana/dashboards/WeeklyBugRetro.json | 30 +++++++++++++++---------------
1 file changed, 15 insertions(+), 15 deletions(-)
diff --git a/grafana/dashboards/WeeklyBugRetro.json
b/grafana/dashboards/WeeklyBugRetro.json
index 3b1e9131e..63746d074 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -164,7 +164,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(distinct i.id) as bug_count\n from\n issues as i\n\t join
board_issues bi on i.id = bi.issue_id\n\t join boards b on bi.board_id =
b.id\n where \n i.type in (${issue_type})\n and
$__timeFilter(i.created_date)\n and b.id in (${board_id})\n group by time\n
order by time desc\n),\n\ncalendar_date as(\n\tSELECT CAST(($__timeTo [...]
+ "rawSql": "with bugs as ( \n select \n
DATE_ADD(date(i.created_date), INTERVAL -WEEKDAY(date(i.created_date)) DAY) as
time,\n count(distinct i.id) as bug_count\n from\n issues as i\n\t join
board_issues bi on i.id = bi.issue_id\n\t join boards b on bi.board_id =
b.id\n where \n i.type in (${issue_type})\n and i.status != 'REJECTED'\n
and $__timeFilter(i.created_date)\n and b.id in (${board_id})\n group by
time\n order by time desc\n),\n\ncalendar_da [...]
"refId": "A",
"select": [
[
@@ -302,7 +302,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(distinct i.id) as bug_count\n from\n issues as
i\n\t join board_issues bi on i.id = bi.issue_id\n\t join boards b on
bi.board_id = b.id\n where \n i.type in (${issue_type})\n and status =
'DONE'\n and $__timeFilter(i.resolution_date)\n and b.id in
(${board_id})\n group by time\n order by time desc\n),\n\ncalendar_da [...]
+ "rawSql": "with bugs as (\n select \n
DATE_ADD(date(i.resolution_date), INTERVAL -WEEKDAY(date(i.resolution_date))
DAY) as time,\n count(distinct i.id) as bug_count\n from\n issues as
i\n\t join board_issues bi on i.id = bi.issue_id\n\t join boards b on
bi.board_id = b.id\n where \n i.type in (${issue_type})\n and status =
'DONE'\n and i.status != 'REJECTED'\n and
$__timeFilter(i.resolution_date)\n and b.id in (${board_id})\n group by
time\n order [...]
"refId": "A",
"select": [
[
@@ -442,7 +442,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with calendar_date as(\n\tSELECT
CAST(($__timeTo()-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 SEL [...]
+ "rawSql": "with calendar_date as(\n\tSELECT
CAST(($__timeTo()-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 SEL [...]
"refId": "A",
"select": [
[
@@ -564,7 +564,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(distinct i.id)\nfrom\n issues as i\n
join board_issues bi on i.id = bi.issue_id\n join boards b on bi.board_id =
b.id\nwhere\n i.type in (${issue_type})\n and b.id in (${board_id})\n AND
i.created_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000)) DAY)",
+ "rawSql": "select\n count(distinct i.id)\nfrom\n issues as i\n
join board_issues bi on i.id = bi.issue_id\n join boards b on bi.board_id =
b.id\nwhere\n i.type in (${issue_type})\n and i.status != 'REJECTED'\n and
b.id in (${board_id})\n AND i.created_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000)) DAY)",
"refId": "A",
"select": [
[
@@ -676,7 +676,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n priority,\n count(distinct i.id) as 'Issue
Number'\nfrom\n issues as i\n join board_issues bi on i.id = bi.issue_id\n
join boards b on bi.board_id = b.id\nwhere\n i.type in (${issue_type})\n and
b.id in (${board_id})\n AND i.created_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000)) DAY)\ngroup by 1",
+ "rawSql": "select\n priority,\n count(distinct i.id) as 'Issue
Number'\nfrom\n issues as i\n join board_issues bi on i.id = bi.issue_id\n
join boards b on bi.board_id = b.id\nwhere\n i.type in (${issue_type})\n and
i.status != 'REJECTED'\n and b.id in (${board_id})\n AND i.created_date
BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME [...]
"refId": "A",
"select": [
[
@@ -835,7 +835,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url',\n i.creator_name as 'Creator'\nfrom\n 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 i.type in (${issue_type})\n and b.id in (${board_id})\n AND
i.created_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL [...]
+ "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url',\n i.creator_name as 'Creator'\nfrom\n 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 i.type in (${issue_type})\n and i.status != 'REJECTED'\n and
b.id in (${board_id})\n AND i.created_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000))+7 DAY)\n AND \n DATE_SUB(FROM_UN [...]
"refId": "A",
"select": [
[
@@ -944,7 +944,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(distinct i.id)\nfrom\n 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 i.type in (${issue_type})\n and status = 'DONE'\n and b.id in
(${board_id})\n AND i.resolution_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000)) DAY)",
+ "rawSql": "select\n count(distinct i.id)\nfrom\n 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 i.type in (${issue_type})\n and status = 'DONE'\n and i.status
!= 'REJECTED'\n and b.id in (${board_id})\n AND i.resolution_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__t [...]
"refId": "A",
"select": [
[
@@ -1058,7 +1058,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n avg(lead_time_minutes / 1440)\nfrom\n 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 i.type in (${issue_type})\n and status = 'DONE'\n
and b.id in (${board_id})\n AND i.resolution_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000)) DAY)",
+ "rawSql": "select\n avg(lead_time_minutes / 1440)\nfrom\n 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 i.type in (${issue_type})\n and status = 'DONE'\n
and i.status != 'REJECTED'\n and b.id in (${board_id})\n AND
i.resolution_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIX [...]
"refId": "A",
"select": [
[
@@ -1231,7 +1231,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n lead_time_minutes/1440 as 'Lead Time in Days',\n i.url as
'Url'\nfrom\n 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 i.type in
(${issue_type})\n and status = 'DONE'\n and b.id in (${board_id})\n AND
i.resolution_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL
WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n DA [...]
+ "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n lead_time_minutes/1440 as 'Lead Time in Days',\n i.url as
'Url'\nfrom\n 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 i.type in
(${issue_type})\n and status = 'DONE'\n and i.status != 'REJECTED'\n and
b.id in (${board_id})\n AND i.resolution_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
[...]
"refId": "A",
"select": [
[
@@ -1371,7 +1371,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n concat('#',i.issue_key, ' ', i.title) as
issue_key,\n lead_time_minutes/1440 as lead_time\nfrom\n 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 i.type in (${issue_type})\n and status = 'DONE'\n and b.id in
(${board_id})\n AND i.resolution_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 10 [...]
+ "rawSql": "select\n concat('#',i.issue_key, ' ', i.title) as
issue_key,\n lead_time_minutes/1440 as lead_time\nfrom\n 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 i.type in (${issue_type})\n and status = 'DONE'\n and i.status
!= 'REJECTED'\n and b.id in (${board_id})\n AND i.resolution_date BETWEEN \n
DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to /
1000))+7 DAY)\n AND \n DAT [...]
"refId": "A",
"select": [
[
@@ -1480,7 +1480,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(distinct i.id)\nfrom \n 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 (${board_id})",
+ "rawSql": "select\n count(distinct i.id)\nfrom \n 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 NOT IN ('DONE',
'REJECTED')\n and b.id in (${board_id})",
"refId": "A",
"select": [
[
@@ -1588,7 +1588,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n avg((TIMESTAMPDIFF(MINUTE,
i.created_date,NOW()))/1440)\nfrom \n 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 (${board_id})",
+ "rawSql": "select \n avg((TIMESTAMPDIFF(MINUTE,
i.created_date,NOW()))/1440)\nfrom \n 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 NOT IN ('DONE', 'REJECTED')\n and b.id in
(${board_id})",
"refId": "A",
"select": [
[
@@ -1768,7 +1768,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n i.issue_key as 'Issue Number',\n i.title as
'Title',\n priority as 'Priority',\n severity as 'Severity',\n
(TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time in Days',\n
i.url as 'Url'\nfrom \n 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 (${board_id})\n and
priority in (${priority})\norder by 'Queue Time' desc",
+ "rawSql": "select \n i.issue_key as 'Issue Number',\n i.title as
'Title',\n priority as 'Priority',\n severity as 'Severity',\n
(TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time in Days',\n
i.url as 'Url'\nfrom \n 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 NOT IN ('DONE', 'REJECTED')\n and b.id in
(${board_id})\n and priority in (${priority})\norder by [...]
"refId": "A",
"select": [
[
@@ -1908,7 +1908,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n concat('#', i.issue_key) as issue_key,\n
(TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time in
Days'\nfrom \n 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 (${board_id})\norder by 2 desc\nlimit 100",
+ "rawSql": "select \n concat('#', i.issue_key) as issue_key,\n
(TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time in
Days'\nfrom \n 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 NOT IN ('DONE', 'REJECTED')\n and b.id in (${board_id})\norder by 2
desc\nlimit 100",
"refId": "A",
"select": [
[
@@ -2105,7 +2105,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n i.issue_key as 'Issue Number',\n i.title as
'Title',\n priority as 'Priority',\n severity as 'Severity',\n
(TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time in Days',\n
i.url as 'Url'\nfrom \n 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 i.assignee_name = ''\n and
b.id in (${board_id})\norder by 'Queue Time' desc",
+ "rawSql": "select \n i.issue_key as 'Issue Number',\n i.title as
'Title',\n priority as 'Priority',\n severity as 'Severity',\n
(TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time in Days',\n
i.url as 'Url'\nfrom \n 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 NOT IN ('DONE', 'REJECTED')\n and
i.assignee_name = ''\n and b.id in (${board_id})\norder by 'Que [...]
"refId": "A",
"select": [
[
