This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
oss-health-metrics:metrics:transparency [2017/05/17 23:57] GeorgLink new template |
oss-health-metrics:metrics:transparency [2017/10/06 20:59] (current) GeorgLink fixed link |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Transparency ====== | ====== Transparency ====== | ||
| - | ===== 1. Description ===== | + | Page permanently moved to |
| - | Number of comments per issue. | + | https://github.com/chaoss/metrics/blob/master/activity-metrics/transparency.md |
| - | Discussion is occuring openly - could also indicate level of agreement. | + | |
| - | + | ||
| - | ===== 2. Use Cases ===== | + | |
| - | ===== 3. Sample Visualization ===== | + | |
| - | + | ||
| - | ===== 4. Sample Implementation ===== | + | |
| - | === GitHub === | + | |
| - | 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 | + | |
| - | + | ||
| - | ===== 5. Known Implementations ===== | + | |
| - | + | ||
| - | ===== 6. External References (Literature) ===== | + | |