oss-health-metrics:metrics:issue-comments
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
oss-health-metrics:metrics:issue-comments [2017/04/10 18:58] abuhman created |
oss-health-metrics:metrics:issue-comments [2017/10/06 20:54] (current) GeorgLink fixed link |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Issue Comments ====== | ====== Issue Comments ====== | ||
| - | ===== 1. Acronym ===== | ||
| - | ===== 2. Alternate Names ===== | + | Page permanently moved to |
| - | + | https://github.com/chaoss/metrics/blob/master/activity-metrics/issue-comments.md | |
| - | ===== 3. Classification ===== | + | |
| - | Community Health | + | |
| - | + | ||
| - | ===== 4. Description ===== | + | |
| - | Number of Comments per Issue | + | |
| - | + | ||
| - | ==== Visualization ==== | + | |
| - | + | ||
| - | ==== Interpretation ==== | + | |
| - | + | ||
| - | ===== 5. Known Implementations ===== | + | |
| - | + | ||
| - | ===== 6. Data Source ===== | + | |
| - | GHTorrent | + | |
| - | + | ||
| - | ===== 7. Pseudo Code/Query ===== | + | |
| - | ===Average Comments per Issue per Project=== | + | |
| - | + | ||
| - | SELECT avg(avg_num_comments), project_name | + | |
| - | FROM | + | |
| - | ( | + | |
| - | SELECT count(comment_id) as avg_num_comments, projects.name as project_name, projects.id as project_id | + | |
| - | FROM msr14.issue_comments | + | |
| - | join issues on issue_comments.issue_id = issues.id | + | |
| - | join projects on issues.repo_id = projects.id | + | |
| - | GROUP BY projects.id, issues.id | + | |
| - | ) as comments_per_issue | + | |
| - | GROUP BY project_id | + | |
| - | + | ||
| - | === Number of Issue Comments Over Time=== | + | |
| - | + | ||
| - | SELECT projects.name as project_name, COUNT(issue_comments.comment_id), DATE(issue_comments.created_at) AS date_commented | + | |
| - | FROM issue_comments | + | |
| - | JOIN issues ON issues.id = issue_comments.issue_id | + | |
| - | JOIN projects ON projects.id = issues.repo_id | + | |
| - | GROUP BY projects.id, date_commented | + | |
| - | + | ||
| - | ===Number of Comments per Issue === | + | |
| - | + | ||
| - | SELECT projects.name as project_name, issue_comments.issue_id, COUNT(issue_comments.comment_id) | + | |
| - | FROM issue_comments | + | |
| - | JOIN issues ON issues.id = issue_comments.issue_id | + | |
| - | JOIN projects ON projects.id = issues.repo_id | + | |
| - | GROUP BY issue_comments.issue_id | + | |
| - | + | ||
| - | ===== 8. Data Exchange Format ===== | + | |
| - | + | ||
| - | ===== 9. References to Academic Literature ===== | + | |
| - | + | ||
| - | ===== 10. Internet References ===== | + | |
| - | + | ||
| - | ===== 11. Contributors ===== | + | |
| - | Anna Buhman | + | |
oss-health-metrics/metrics/issue-comments.1491850692.txt.gz · Last modified: 2017/04/10 18:58 by abuhman
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
