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]

Reply via email to