User Tools

Site Tools


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

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oss-health-metrics:metrics:issues-submitted-closed [2017/04/26 21:06]
abuhman [7. Known Implementations]
oss-health-metrics:metrics:issues-submitted-closed [2017/10/06 20:56] (current)
GeorgLink fixed link
Line 1: Line 1:
 ====== Issues submitted/​closed ====== ====== Issues submitted/​closed ======
-===== 1. Acronym ===== 
  
-===== 2. Alternate Names ===== +Page permanently moved to 
- +https://​github.com/​chaoss/metrics/​blob/​master/​activity-metrics/​issues-submitted-closed.md
-===== 3. Classification ===== +
- +
-===== 4. Description ===== +
-Issues submitted vs. issues closed +
- +
-==== Pseudo Code ==== +
-==== Visualization ==== +
-==== Interpretation ==== +
- +
-===== 5. Pseudo Code/Query ===== +
- +
-===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 +
- +
-===== 6. Data Exchange Format ===== +
- +
-===== 7. Known Implementations ===== +
-[[https://​github.com/​OSSHealth/ghdata|GHData]] +
-===== 8References to Academic Literature ===== +
- +
-===== 9. Internet References ===== +
- +
-===== 10. Contributors ===== +
-Anna Buhman+
oss-health-metrics/metrics/issues-submitted-closed.1493240781.txt.gz · Last modified: 2017/04/26 21:06 by abuhman