Differences

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

--- 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/09/09 23:50]
GeorgLink Page permanently moved
@@ Line 1: / Line 1: @@
-__**[[oss-health-metrics:metrics|<< Back to List of Activity Metrics]]**__
 ====== Issues submitted/closed ======
-===== 1. Description =====
+Page permanently moved to
-Issues submitted vs. issues closed
+https://github.com/chaoss/metrics/blob/master/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 (Literature) =====

Wiki