JQL for Created vs Resolved

[Jeniffer Kamaraj]

Hi team, 

Can I know the JQL for Created vs Resolved in a month for multiple project? Or single project

[Walter Buggenhout · Accepted solution]

Hi @Jeniffer Kamaraj,

There is not really a JQL for created vs resolved. What you can do, is add a created vs resolved gadget on a Jira dashboard and simply add a Jira project as the source for the gadget.

This will then display issues created and resolved lines on the chart, based on the created and resolved dates of the issues in your project.

Instead of a single project, you can also add a filter as the gadget source. Again, that should only include the list of projects you want to report on. The gadget takes care of the rest.

Hope this helps! 

[Jeniffer Kamaraj]

Okay this helps . 

But if i want to do filter for single project, may I know the JQL if I pull out within a month data ?

[Walter Buggenhout]

Suppose you want to pull all issues that were created or resolved during the previous month, you can do something like this:

(created >= startOfMonth(-1) AND created <= endOfMonth(-1)) OR
(resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1))

But, honestly, that filter will do nothing but give you a list of issues. The chart allows you to group the data by day / week / month / quarter or even year, like this:

[Jeniffer Kamaraj]

Thanks! Helps alot