nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get the number of open tickets ?

Pierre G_xu0g78

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!

Accepted answers

Sachin Dhamale_o1c5zi

@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_xu0g78

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.

All comments

Fabio Racobaldo _Catworkx_

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_xu0g78

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...

Sachin Dhamale_o1c5zi

@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_xu0g78

Hi,

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

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

Sachin Dhamale_o1c5zi

@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,

Cre vs Reso.png

Created Vs Resolve.png

Fabio Racobaldo _Catworkx_

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

Ciao,

Fabio

Lauma Cīrule

Hi,

@Fabio Racobaldo _Catworkx_ , 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

Pierre G_xu0g78

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software