Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Resolved issues for every moths

Giacomo Gianola
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 10, 2021

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

1 answer

0 votes
Alex Koxaras -Relational-
Community Champion
September 10, 2021

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:

createdVSresolved.png

Giacomo Gianola
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 10, 2021

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

Suggest an answer

Log in or Sign up to answer