What is this metric?
The time it takes from when a PR is issued until the first comment is added to that PR.
Why is it important?
PR Pickup Time shows how engaged your team is in collaborative work by identifying the delay in picking up PRs.
Which dashboard(s) does it exist in?
How is it calculated?Data Sources Required
This metric relies on PRs/MRs collected from GitHub, GitLab, BitBucket, Gitee or other code review tools.Data Transformation Required
The following SQL shows how to find the
pickup time of a specific PR. DevLake pre-calculates the metric and stores it in table.project_pr_metrics.
pr_pickup_time/60 as 'PR Pickup Time(h)'
If you want to measure the monthly trend of
PR pickup time in the screenshot below, please run the following SQL in Grafana.
DATE_ADD(date(pr.created_date), INTERVAL -DAY(date(pr.created_date))+1 DAY) as time,
avg(ppm.pr_pickup_time)/60 as 'PR Pickup Time(h)'
JOIN project_pr_metrics ppm ON pr.id = ppm.id
GROUP BY 1
ORDER BY 1
How to improve?
- Use DevLake's dashboard to monitor your delivery progress;
- Have a habit to check for hanging PRs regularly;
- Set up alerts for your communication tools (e.g. Slack, Lark) when new PRs are issued.