oss-health-metrics:metrics:issues-open
This is an old revision of the document!
Table of Contents
<< Back to List of Activity Metrics
Issues Open
1. Description
Number of open issues
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)
oss-health-metrics/metrics/issues-open.1495066513.txt.gz · Last modified: 2017/05/18 00:15 by GeorgLink
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
