User Tools

Site Tools


oss-health-metrics:metrics:issues-submitted-closed

This is an old revision of the document!


Issues submitted/closed

1. Description

Issues submitted vs. issues closed

2. Use Cases

3. Sample Visualization

4. Sample Implementation

GHTorrent: Total issues by project

select count(issues.id) as total_issues, projects.name as project_name, projects.url as project_url from
issues join projects
on issues.repo_id = projects.id
group by projects.id

GHTorrent: Total closed issues by project

select count(distinct issues.id) as total_issues, projects.name as project_name, projects.url as project_url 
from    
issues join projects
on issues.repo_id = projects.id
join issue_events
on issue_events.issue_id = issues.id
where issue_events.action = 'closed'
group by projects.id

5. Known Implementations

6. External References (Literature)

oss-health-metrics/metrics/issues-submitted-closed.1495066125.txt.gz · Last modified: 2017/05/18 00:08 by GeorgLink