I am trying to report on the average number of tickets that were open at any given time over the last X days, however I don't see any means of doing this.
Has anyone had any experience with this?
You can use a gadget "Issue Statistics" on Dashboard either based on resolution or based on status. Check screenshots attached.
with saved filter (JQL)
resolution is EMPTY AND updated >= startOfMonth()
You can update the updated as per your needs. The above filter gives all unresolved issues from start of the month.(say for all May tickets)
If you want a sql query
select count(*) from jiraissue WHERE RESOLUTION IS NULL AND UPDATED >= 'XXXXX'
Hope this helps
Chander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.