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; } } }

Monthly tickets created and resolved

Trisha_Colotto

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.

Accepted answers

Trudy P Claspill

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

Gorka Puente {Appfire}

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

All comments

Trudy P Claspill

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

Gorka Puente {Appfire}

Hi @Trisha_Colotto ,

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

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

Hope this helps,

Gorka

Trisha_Colotto

Hi Gorka,

This is perfect, exactly what I was after.

Thank you so much :-)

Trisha_Colotto

Hi Trudy,

Thank you these were very helpful.

Gorka Puente {Appfire}

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

Welcome!

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

Quick Links

Find more posts tagged with

jira-software

report