Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JIRA report to show closed tickets from last month

Im trying to create a report for tickets closed last month. I have ticket closed this month see below. Any help would be appreciated.

 

"Assigned IT Service Team" = EnterpriseSystems AND status = resolved AND resolved >= startOfMonth() OR "Assigned IT Service Team" = EnterpriseSystems AND status = Closed AND resolved >= startOfMonth()

2 answers

1 accepted

7 votes
Answer accepted
Ivan Tovbin Community Leader Mar 13, 2018

This JQL should do the trick:

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

Thank  you for responding. I tried that and it shows me resolved from Feb 2018 to March 2018. I want to only see resolved in Feb.

That's odd. I've just tried it in my instance and it returned issues resolved ONLY in Feb 2018. Are you positive that you have used the EXACT JQL I've provided?

To be extra clear, it could've returned issues resolved in Feb 2018 AND March 2018 ONLY if you've used:

resolved >= startOfMonth(-1)

However it will limit the issues ONLY by Feb 2018 if you will use:

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

 

Looks like it is now working. I must have miss something. thanks

Ivan Tovbin Community Leader Mar 15, 2018

Glad I could help. Please mark this solution as "Accepted" if it resolved your issue.

1 vote
.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

3,934 views 11 5
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you