User Tools

Site Tools


oss-health-metrics:metrics:transparency

This is an old revision of the document!


<< Back to List of Activity Metrics

Transparency

1. Description

Number of comments per issue. Discussion is occuring openly - could also indicate level of agreement.

2. Use Cases

3. Sample Visualization

4. Sample Implementation

GitHub

SELECT avg(avg_num_comments), project_name
FROM
(
	SELECT count(comment_id) as avg_num_comments, projects.name as project_name, projects.id as project_id
	FROM msr14.issue_comments
		join issues on issue_comments.issue_id = issues.id
		join projects on issues.repo_id = projects.id
	GROUP BY projects.id, issues.id
) as comments_per_issue
GROUP BY project_id

5. Known Implementations

6. External References (Literature)

oss-health-metrics/metrics/transparency.1495066403.txt.gz · Last modified: 2017/05/18 00:13 by GeorgLink