Resolved issues for every moths

Question

Hi all,

new to Jira!

I'm trying to create a two dimensional table showing resolved issues aggregates by months.

So far i wrote this JQL

status changed to ("IssueCheck") during (startOfMonth(), endOfMonth()) and status in ("IssueCheck", "Closed")I need to count all the closed/IssueCheck status, that move to IssueCheck status in a variable month. Of course aggregates by months.Is it possible to parameterize startOfMonth() and endOfMonth()?Thank you all

Giacomo Gianola · Answer

Thank you @Alex Koxaras -Relational- !

I tried with adding a parameter inside the parenthesis, but this allow me to view a specific interval. What i'm looking for is to consider all the jira ticket and grouping them by month.

Also tried with the created vs resolve widget, but i need to modify the closed logic behind this graph, and i think it's not permitted/possible.

Giacomo

Alex Koxaras -Relational- · Answer

Hi @Giacomo Gianola and welcome!

You may see the use of this function here https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

Some quick examples of how you can work with this function would be:

* Find new issues created since the start of this month:
created > startOfMonth()

* Find new issues created since the start of last month:
created > startOfMonth("-1")

* Find new issues created since the 15th of this month:
created > startOfMonth("+14d")

Other than that, you can't set another parameter inside the parenthesis. There could be apps in the marketplace which could do the thing you want.

As a last solution you could use the created vs resolve widget in a dashboard, and tweak it to your likings: