Differences

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

--- oss-health-metrics:metrics:issues-submitted-closed [2017/05/16 17:12]
klumbard
+++ oss-health-metrics:metrics:issues-submitted-closed [2017/10/06 20:56] (current)
GeorgLink fixed link
@@ Line 1: / Line 1: @@
 ====== 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]]
-===== 6. External References to (Literature) =====

Wiki