oss-health-metrics:metrics:issue-response-rate
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
oss-health-metrics:metrics:issue-response-rate [2017/04/05 19:40] abuhman [11. Contributors] |
oss-health-metrics:metrics:issue-response-rate [2017/09/09 23:48] GeorgLink Page permanently moved |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Issue Response Rate ====== | ====== Issue Response Rate ====== | ||
| - | ===== 1. Acronym ===== | ||
| - | |||
| - | |||
| - | ===== 2. Alternate Names ===== | ||
| - | |||
| - | ===== 3. Classification ===== | ||
| - | Community Health | ||
| - | |||
| - | ===== 4. Description ===== | ||
| - | Time between a new issue is opened and a maintainer responds | ||
| - | Also called: bug response rate. The maintainer is believed to not “pile on” but try to solve an issue. | ||
| - | |||
| - | ==== Visualization ==== | ||
| - | |||
| - | |||
| - | ==== Interpretation ==== | ||
| - | |||
| - | |||
| - | ===== 5. Known Implementations ===== | ||
| - | |||
| - | |||
| - | ===== 6. Data Source ===== | ||
| - | GHTorrent Database | ||
| - | |||
| - | ===== 7. Pseudo Code/Query ===== | ||
| - | === Average days an issue tagged with 'bug' exists until a project member comments (all projects) === | ||
| - | |||
| - | SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | ||
| - | FROM | ||
| - | ( | ||
| - | SELECT DATEDIFF(earliest_member_comment, issue_created) time_to_member_comment_in_days, project_id, issue_id, project_name, url | ||
| - | FROM | ||
| - | (SELECT projects.id as project_id, | ||
| - | MIN(issue_comments.created_at) as earliest_member_comment, | ||
| - | issues.created_at as issue_created, | ||
| - | issues.id as issue_id, projects.name as project_name, url | ||
| - | FROM msr14.repo_labels | ||
| - | join projects on repo_labels.repo_id = projects.id | ||
| - | join issue_labels on issue_labels.label_id = repo_labels.id | ||
| - | join project_members on projects.id = project_members.repo_id | ||
| - | join issues on issue_labels.issue_id = issues.id | ||
| - | join issue_comments on issue_comments.issue_id = issues.id | ||
| - | where repo_labels.name = 'bug' | ||
| - | and issue_comments.user_id = project_members.user_id | ||
| - | group by issues.id) as earliest_member_comments) as time_to_member_comment | ||
| - | group by project_id | ||
| - | |||
| - | === Average days an issue (any tag or no tag) exists until a project member comments (all projects) === | ||
| - | |||
| - | SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | ||
| - | FROM | ||
| - | ( | ||
| - | SELECT DATEDIFF(earliest_member_comment, issue_created) time_to_member_comment_in_days, project_id, issue_id, project_name, url | ||
| - | FROM | ||
| - | (SELECT projects.id as project_id, | ||
| - | MIN(issue_comments.created_at) as earliest_member_comment, | ||
| - | issues.created_at as issue_created, | ||
| - | issues.id as issue_id, projects.name as project_name, url | ||
| - | FROM projects | ||
| - | join project_members on projects.id = project_members.repo_id | ||
| - | join issues on issues.repo_id = projects.id | ||
| - | join issue_comments on issue_comments.issue_id = issues.id | ||
| - | where issue_comments.user_id = project_members.user_id | ||
| - | group by issues.id) as earliest_member_comments) as time_to_member_comment | ||
| - | group by project_id | ||
| - | |||
| - | === Time between opening and a committer responding to an issue (single project) === | ||
| - | |||
| - | SELECT issues.id AS "issue_id", | ||
| - | issues.created_at AS "created_at", | ||
| - | MIN(issue_comments.created_at) AS "responded_to" | ||
| - | FROM issues | ||
| - | JOIN issue_comments | ||
| - | ON issue_comments.issue_id = issues.id | ||
| - | WHERE issue_comments.user_id IN | ||
| - | (SELECT users.id | ||
| - | FROM users | ||
| - | JOIN commits | ||
| - | WHERE commits.author_id = users.id | ||
| - | AND commits.project_id = 78852) | ||
| - | AND issues.repo_id = 78852 | ||
| - | GROUP BY issues.id | ||
| - | |||
| - | ===== 8. Data Exchange Format ===== | ||
| - | |||
| - | ===== 9. References to Academic Literature ===== | ||
| - | |||
| - | |||
| - | ===== 10. Internet References ===== | ||
| - | |||
| - | |||
| - | ===== 11. Contributors ===== | ||
| + | Page permanently moved to | ||
| + | https://github.com/chaoss/metrics/blob/master/metrics/issue-response-rate.md | ||
oss-health-metrics/metrics/issue-response-rate.txt · Last modified: 2017/10/06 20:55 by GeorgLink
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
