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/05/18 00:15]
GeorgLink add link back to list
oss-health-metrics:metrics:issues-submitted-closed [2017/10/06 20:56] (current)
GeorgLink fixed link
Line 1: Line 1:
-__**[[oss-health-metrics:​metrics|<<​ Back to List of Activity Metrics]]**__ 
 ====== Issues submitted/​closed ====== ====== Issues submitted/​closed ======
  
-===== 1. Description ===== +Page permanently moved to 
-Issues submitted vs. issues closed +https://​github.com/​chaoss/metrics/​blob/​master/​activity-metrics/​issues-submitted-closed.md
- +
-===== 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 ===== +
-[[https://​github.com/​OSSHealth/ghdata|GHData]] +
- +
-===== 6External References (Literature) ===== +
oss-health-metrics/metrics/issues-submitted-closed.1495066504.txt.gz · Last modified: 2017/05/18 00:15 by GeorgLink