Skip to content

Latest commit

 

History

History
59 lines (42 loc) · 1.68 KB

PRPickupTime.md

File metadata and controls

59 lines (42 loc) · 1.68 KB
Raw
title description sidebar_position
PR Pickup Time
PR Pickup Time
16

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

N/A

SQL Queries

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.

SELECT
  pr_pickup_time/60 as 'PR Pickup Time(h)'
FROM
  project_pr_metrics

If you want to measure the monthly trend of PR pickup time in the screenshot below, please run the following SQL in Grafana.

SELECT 
  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)'
FROM 
  pull_requests pr
  JOIN project_pr_metrics ppm ON pr.id = ppm.id
GROUP BY 1
ORDER BY 1

How to improve?

  1. Use DevLake's dashboard to monitor your delivery progress;
  2. Have a habit to check for hanging PRs regularly;
  3. Set up alerts for your communication tools (e.g. Slack, Lark) when new PRs are issued.