How to Report on Average Number of Open Tickets for the last X Days

[John Rauser]

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?

[Chander Inguva]

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