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:issues-open [2017/05/18 00:15] GeorgLink add link back to list |
oss-health-metrics:metrics:issues-open [2017/10/06 20:55] (current) GeorgLink fixed link |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | __**[[oss-health-metrics:metrics|<< Back to List of Activity Metrics]]**__ | ||
====== Issues Open ====== | ====== Issues Open ====== | ||
- | ===== 1. Description ===== | + | Page permanently moved to |
- | Number of open issues | + | https://github.com/chaoss/metrics/blob/master/activity-metrics/issues-open.md |
- | + | ||
- | ===== 2. Use Cases ===== | + | |
- | + | ||
- | ===== 3. Sample Visualization ===== | + | |
- | + | ||
- | ===== 4. Sample Implementation ===== | + | |
- | ===GHTorrent: Number of Open Issues (current)=== | + | |
- | + | ||
- | SELECT count(distinct issue_events.issue_id) as num_open_issues, projects.name as project_name, url as url | + | |
- | FROM msr14.issue_events | + | |
- | join issues on issues.id = issue_events.issue_id | + | |
- | join projects on issues.repo_id = projects.id | + | |
- | where issue_events.issue_id not in | + | |
- | (SELECT issue_id FROM msr14.issue_events | + | |
- | where action = 'closed') | + | |
- | group by projects.id | + | |
- | + | ||
- | + | ||
- | ===== 5. Known Implementations ===== | + | |
- | + | ||
- | ===== 6. External References (Literature) ===== | + |