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 Next revision Both sides next revision | ||
|
oss-health-metrics:metrics:issue-response-rate [2017/04/05 19:29] abuhman [7. Pseudo Code/Query] |
oss-health-metrics:metrics:issue-response-rate [2017/05/18 00:15] GeorgLink add link back to list |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | __**[[oss-health-metrics:metrics|<< Back to List of Activity Metrics]]**__ | ||
| ====== Issue Response Rate ====== | ====== Issue Response Rate ====== | ||
| - | ===== 1. Acronym ===== | ||
| - | + | ===== 1. Description ===== | |
| - | ===== 2. Alternate Names ===== | + | |
| - | + | ||
| - | ===== 3. Classification ===== | + | |
| - | Community Health | + | |
| - | + | ||
| - | ===== 4. Description ===== | + | |
| Time between a new issue is opened and a maintainer responds | 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. | Also called: bug response rate. The maintainer is believed to not “pile on” but try to solve an issue. | ||
| - | ==== Visualization ==== | + | Below queries are using users with commit rights, not maintainer. |
| + | ===== 2. Use Cases ===== | ||
| - | ==== Interpretation ==== | + | ===== 3. Sample Visualization ===== |
| - | + | ===== 4. Example Implementation ===== | |
| - | ===== 5. Known Implementations ===== | + | ===GHTorrent: Average days an issue tagged with 'bug' exists until a project member comments (all projects) === |
| - | + | ||
| - | + | ||
| - | ===== 6. Data Source ===== | + | |
| - | GHTorrent Database | + | |
| - | + | ||
| - | ===== 7. Pseudo Code/Query ===== | + | |
| - | ### Average days an issue tagged with 'bug' exists until a project member comments: | + | |
| SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | ||
| Line 47: | Line 35: | ||
| group by project_id | group by project_id | ||
| - | ### Average days an issue (any tag or no tag) exists until a project member comments: | + | ===GHTorrent: 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 | SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | ||
| Line 66: | Line 54: | ||
| group by project_id | group by project_id | ||
| - | ### Time between opening and a committer responding to an issue | + | ===GHTorrent: Time between opening and a committer responding to an issue (single project) === |
| - | ```sql | + | SELECT issues.id AS "issue_id", |
| - | SELECT issues.id AS "issue_id", | + | issues.created_at AS "created_at", |
| - | issues.created_at AS "created_at", | + | MIN(issue_comments.created_at) AS "responded_to" |
| - | MIN(issue_comments.created_at) AS "responded_to" | + | FROM issues |
| - | FROM issues | + | JOIN issue_comments |
| - | JOIN issue_comments | + | ON issue_comments.issue_id = issues.id |
| - | ON issue_comments.issue_id = issues.id | + | WHERE issue_comments.user_id IN |
| - | WHERE issue_comments.user_id IN | + | (SELECT users.id |
| - | (SELECT users.id | + | FROM users |
| - | FROM users | + | JOIN commits |
| - | JOIN commits | + | WHERE commits.author_id = users.id |
| - | WHERE commits.author_id = users.id | + | AND commits.project_id = 78852) |
| - | AND commits.project_id = 78852) | + | AND issues.repo_id = 78852 |
| - | AND issues.repo_id = 78852 | + | GROUP BY issues.id |
| - | GROUP BY issues.id | + | |
| - | ``` | + | |
| - | ===== 8. Data Exchange Format ===== | + | ===== 5. Known Implementations ===== |
| - | Describe how the metric is encoded for sharing and communicating between programs. | + | |
| - | ===== 9. References to Academic Literature ===== | + | [[https://github.com/OSSHealth/ghdata|GHData]] |
| - | Papers released in the academic literature that uses the metric. | + | |
| - | ===== 10. Internet References ===== | + | ===== 6. External References (Literature) ===== |
| - | Links to websites that add value to the understanding of the metric. | + | |
| - | ===== 11. Contributors ===== | ||
| - | Authors of the metric page and authors who made significant changes. | ||
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
