How to get the number of open tickets ?

[Pierre G]

Hi,

I search to know how to get the number of open tickets during the year by period of 1 month. Can you help me please ?

I precise that i don't want the number of ticket create during each month but the number of ticket with "not close" state during each.

Ex : 

A ticket create in January and close in march will be counted in January, February anr March.

Thanks!

[Pierre G · Accepted solution]

Hi all,
Thanks for your response. I find/undertand the solution.

The widget Created vs Resolved is effectively what i want...

• Select "Display the trend of Unresolved"
• Be sure that the "Days previously" is bigger than your project. That was why the result wasn't good for me...
• I have 22 tickets open in March 2022 :
• 

Thanks all.

[Sachin Dhamale · Accepted solution]

@Pierre G ,

Welcome to the Community

If you using resolution field then you can use following JQL to get open issues

resolution = Unresolved and created = startOfMonth("-1")  - you can change the parameter of startOfmonth based on the month for which you want to search data.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-startOfMonth

[Pierre G]

Hi,

Sorry i didn't say that i wanted a visual Graph...

Sorry again, i am not used to speak english...

[Sachin Dhamale]

@Pierre G ,

For your requirement we don't have the gadget which will fulfill requirement

you can use Created vs Resolve Gadget but it also not complete your requirement,

[Fabio Racobaldo _Herzum_]

Hi @Pierre G ,

welcome to the Atlassian community!

Created vs Resolved report, provided as a gadget for a dashoard, should help you for you needs.

https://community.atlassian.com/t5/Jira-articles/quot-Created-vs-Resolved-quot-report/ba-p/1553129#:~:text=How%20the%20report%20is%20calculated,have%20resolution%20and%20resolution%20date.

Hope this helps,

Fabio

[Pierre G]

Hi,

Thansk but no, it's not what i want...

This widget get the number of ticket create, and solved, not tue number of ticket wich is not close.

This widget contains an option "Display the Trend of Unresolved" but i don't undestand how it's work. The number of "unresolved ticket" doesn't match with my data...

[Fabio Racobaldo _Herzum_]

Based on your requirement you should an outofthebox app. My suggestion is EazyBI.

Ciao,

Fabio

[Lauma Cīrule]

Hi, 

@Fabio Racobaldo _Herzum_ , thanks for suggesting eazyBI!

Additionally, here is a sample report showing issues created, resolved, and open over time: https://eazybi.com/accounts/1000/cubes/Issues/reports/80614-created-vs-resolved-issues-over-time.

Lauma / support@eazybi.com