Startrekzky commented on code in PR #4267:
URL:
https://github.com/apache/incubator-devlake/pull/4267#discussion_r1090411725
##########
grafana/dashboards/EngineeringThroughputAndCycleTime.json:
##########
@@ -167,7 +167,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n DATE_ADD(date(pr.created_date), INTERVAL
-$interval(date(pr.created_date))+1 DAY) as time,\n count(id) as \"PR:
Opened\",\n count(distinct case when pr.merged_date is not null then id else
null end) as \"PR: Merged\"\nFROM pull_requests pr\n join project_mapping pm
on pr.base_repo_id = pm.row_id\nWHERE\n $__timeFilter(pr.created_date)\n and
pm.project_name in ($project)\ngroup by 1\n",
+ "rawSql": "SELECT\n DATE_ADD(date(pr.created_date), INTERVAL
-$interval(date(pr.created_date))+1 DAY) as time,\n count(distinct id) as
\"PR: Opened\",\n count(distinct case when pr.merged_date is not null then id
else null end) as \"PR: Merged\"\nFROM pull_requests pr\n join project_mapping
pm on pr.base_repo_id = pm.row_id\nWHERE\n $__timeFilter(pr.created_date)\n
and pm.project_name in ($project)\ngroup by 1\n",
Review Comment:
Let's use pr.id to make it preciser?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]