Monitor issue resolution times by project
SQL query for Jira
Get the average resolution time of issues for each project in Jira.
SELECT project, AVG(DATEDIFF(‘day’, created_date, resolution_date)) AS avg_resolution_time FROM issues GROUP BY project;
Jira data model
Accessible Resources
Users
Issuetype
Status
Issues
Projects
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.
- 14-day free trial
- No credit card needed