Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,368,039
Community Members
 
Community Events
168
Community Groups

Monthly tickets created and resolved

Edited

Hi,

I am using Dashboard Hub Add-on and need 2 separate JQL queries to obtain the following information.

First is to list the total of created/closed tickets per month

The second is to list the totality of created tickets assigned/closed per month by multiple assignees 

For example I started with this and was going to continue with Start/end of month -2 etc, then list by assigned ("Tom", "Joe") etc...

(project = "OOO") AND createdDate was in ("In progress", "Code Review", "Ready for Release") DURING (startOfMonth(-1), endOfMonth(-1))

JQL Query.png 

I appreciate any assistance or advice you can provide, thank you.

2 answers

2 accepted

3 votes
Answer accepted

Hi @Trisha_Colotto ,

This is Gorka, from Appfire, makers of Dashboard Hub for Jira.

We have created a dashboard for you here, so you can see all our examples 🙂 If you are looking for Created vs Resolved requests for Jira Service Management, you can use the Created vs Resolved Requests gadget (slide 1).

In case you want to see any Jira issue, you can either use the JQL Custom Charts gadget (Slide 2 and 3) or the Formula Cards gadget (Slide 2).

JQL Custom Charts:

You need to create one chart for the created issues and other for the resolved issues, with the following configuration:

Screenshot 2022-09-22 at 17.15.14.png

Screenshot 2022-09-22 at 17.15.32.png

To get the following results (you can represent the data as line charts, tile charts…):

Screenshot 2022-09-22 at 17.13.15.png

Screenshot 2022-09-22 at 17.13.52.png

You can also use the Formula Cards gadget to represent the percentage of resolved vs created issues:

Screenshot 2022-09-22 at 17.17.36.png

Variable a with the query

project = "Your Project"  and createdDate >= startOfMonth() and createdDate <= endOfMonth()

And Variable b with the query

project = "Your Project" and resolutionDate >= startOfMonth() and resolutionDate <= endOfMonth() and resolution = Done

Then configure as a Donut Card, where the expression is the resolved issues and the max value of our percentage is the total created issues:

Screenshot 2022-09-22 at 17.17.50.png

We are also working on a specific gadget for Created vs Resolved Issues for Jira issues (not just requests from Jira Service Management like our current gadget Created vs Resolved Requests. We’ll notify you as soon as it’s ready.

Hope this helps,

Gorka

Hi Gorka,

This is perfect, exactly what I was after.

Thank you so much :-)

Like • # people like this

My pleasure, let me know if I can be of further help :)

Like • Sivaiah Muppa likes this
1 vote
Answer accepted

I haven't worked with Data Hub, but I can speak to the JQL filters needed.

JQL to get issues created in the current month:

project = X and createdDate >= startOfMonth() and createdDate <= endOfMonth() 

JQL to get issues closed in the current month:

project = X and resolutionDate >= startOfMonth() and resolutionDate <= endOfMonth() 

If you want to order the output by Assignee then tack onto the end of the above statements the following:

ORDER BY Assignee ASC

Hi Trudy,

Thank you these were very helpful.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events