1 answer
Chander Inguva
Rising Star 
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
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.