Issue resolution time by project - Github SQL Query - Peliqan

Issue resolution time by project

SQL query for Github

Get the average resolution time of issues in each project.

SELECT project, AVG(DATEDIFF(closed_at, created_at)) AS avg_resolution_time FROM issues GROUP BY project;

Github data model

Commits

Pull Requests

Issues

Files

Repos

Labels

Releases

Assignees

Ready to get instant access to all your company data ?

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.