This is an old revision of the document!
<< Back to List of Activity Metrics
Issues submitted vs. issues closed
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
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