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 de6853952 feat: updated pr-status-realated metrics (#5144)
de6853952 is described below
commit de6853952255efbf21cc3257d78ede1df58781ff
Author: abeizn <[email protected]>
AuthorDate: Wed May 10 18:34:18 2023 +0800
feat: updated pr-status-realated metrics (#5144)
* feat: updated pr-status-realated metrics
* feat: add pr-status-realated metrics notes
* fix: pr status dashboard bugs
* fix: pr status dashboard bugs
---
grafana/dashboards/BitBucket.json | 16 ++++++++--------
grafana/dashboards/ContributorExperience.json | 12 ++++++------
grafana/dashboards/GitHub.json | 16 ++++++++--------
grafana/dashboards/Gitlab.json | 20 ++++++++++----------
4 files changed, 32 insertions(+), 32 deletions(-)
diff --git a/grafana/dashboards/BitBucket.json
b/grafana/dashboards/BitBucket.json
index 0d2060d66..f6eb4804e 100644
--- a/grafana/dashboards/BitBucket.json
+++ b/grafana/dashboards/BitBucket.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 28,
- "iteration": 1682062771301,
+ "id": 13,
+ "iteration": 1683688425813,
"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
= 'MERGED' and pr.merged_date is not null\ngroup by 1\norder by 2 desc\nlimit
20\n",
+ "rawSql": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\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
= 'MERGED'\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='DECLINED' then
id else null end)/count(distinct case when status in ('MERGED','DECLINED') 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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\n count(distinct case when
status='CLOSED' then id else null end)/count(distinct case when status in
('MERGED','CLOSED') 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 = 'OPEN' then id else null end) as \"PR: Open\",\n count(distinct case
when status = 'DECLINED' and merged_date is null then id else null end) as
\"PR: Closed without merging\",\n count(distinct case when status = 'MERGED'
and merged_date is not null then id else null end) as \"PR: Merged\"\nFROM
pull_requests\nWHERE\n $__timeFilter(cr [...]
+ "rawSql": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nSELECT\n DATE_ADD(date(created_date),
INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case
when status = 'OPEN' then id else null end) as \"PR: Open\",\n count(distinct
case when status = 'CLOSED' then id else null end) as \"PR: Closed without
merging\",\n count(distinct case [...]
"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 = 'DECLINED'",
+ "rawSql": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\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
= 'CLOSED'",
"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 = 'DECLINED' then id else null end)/count(distinct case when status in
('MERGED', 'DECLINED') 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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nSELECT\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)/count(distinct case when status
in ('MERGED', 'CLOSED') then id else null end) as ratio\nFROM
pull_requests\nWHERE\n $__timeFilter(created_da [...]
"refId": "A",
"select": [
[
@@ -966,5 +966,5 @@
"timezone": "",
"title": "BitBucket",
"uid": "4LzQHZa4k",
- "version": 1
+ "version": 8
}
\ No newline at end of file
diff --git a/grafana/dashboards/ContributorExperience.json
b/grafana/dashboards/ContributorExperience.json
index 9a77d2294..20af955f5 100644
--- a/grafana/dashboards/ContributorExperience.json
+++ b/grafana/dashboards/ContributorExperience.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 24,
- "iteration": 1682062826895,
+ "id": 10,
+ "iteration": 1683690480749,
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field
`original_status`\nselect\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', ' [...]
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\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 DAYOFMON [...]
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\n 100 * count(distinct case when
status = 'CLOSED' 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 date(created_date) BETWEEN\n curdate() - INTERVAL
DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month [...]
"refId": "A",
"select": [
[
@@ -828,5 +828,5 @@
"timezone": "",
"title": "Contributor Experience",
"uid": "bwsP5Nz4z",
- "version": 9
+ "version": 6
}
\ No newline at end of file
diff --git a/grafana/dashboards/GitHub.json b/grafana/dashboards/GitHub.json
index 30fee78dc..5dd0ce34a 100644
--- a/grafana/dashboards/GitHub.json
+++ b/grafana/dashboards/GitHub.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 3,
- "iteration": 1682062979883,
+ "id": 26,
+ "iteration": 1683710488565,
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\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
= 'MERGED'\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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\n count(distinct case when status =
'MERGED' 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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nSELECT\n DATE_ADD(date(created_date),
INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case
when status = 'OPEN' then id else null end) as \"PR: Open\",\n count(distinct
case when status = 'CLOSED' then id else null end) as \"PR: Closed without
merging\",\n count(distinct case [...]
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\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
= 'CLOSED'",
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nSELECT\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)/count(distinct case when status
in ('CLOSED', 'MERGED') then id else null end) as ratio\nFROM
pull_requests\nWHERE\n $__timeFilter(created_da [...]
"refId": "A",
"select": [
[
@@ -1999,5 +1999,5 @@
"timezone": "",
"title": "GitHub",
"uid": "KXWvOFQnz",
- "version": 13
+ "version": 10
}
\ No newline at end of file
diff --git a/grafana/dashboards/Gitlab.json b/grafana/dashboards/Gitlab.json
index b0f084126..bbe74f64f 100644
--- a/grafana/dashboards/Gitlab.json
+++ b/grafana/dashboards/Gitlab.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 26,
- "iteration": 1677590524546,
+ "id": 16,
+ "iteration": 1683687670575,
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\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
= 'MERGED'\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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\n count(distinct case when status =
'CLOSED' 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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nSELECT\n DATE_ADD(date(created_date),
INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case
when status = 'OPEN' then id else null end) as \"PR: Open\",\n count(distinct
case when status = 'CLOSED' then id else null end) as \"PR: Closed without
merging\",\n count(distinct case [...]
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nselect\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
= 'CLOSED'",
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nSELECT\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)/count(distinct case when status
in ('CLOSED', 'MERGED') then id else null end) as ratio\nFROM
pull_requests\nWHERE\n $__timeFilter(created_da [...]
"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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field
`original_status`\nselect\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": "-- The PR/MR statuses are standardized to DevLake's
statuses 'OPEN', 'MERGED' and 'CLOSED'. You can check out the original status
from the field `original_status`\nwith _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 ( [...]
"refId": "A",
"select": [
[
@@ -1143,5 +1143,5 @@
"timezone": "",
"title": "GitLab",
"uid": "msSjEq97z",
- "version": 10
+ "version": 8
}
\ No newline at end of file
