CODEWITHSUNDEEP
jira
AskMe
AskMe

Reputation: 2577

How to find JIRA cases resolved or done by users in any given month or week?

I have this JQL which gives me the details about the cases resolved/closed/done by me:

  assignee = currentUser() AND statusCategory = Done order by updated DESC

This works fine. However, my question is; How do I get the cases closed/done by perticular user in any given month or week?Any JQL query please? Also, Is there any query that can give me a count as well?

EDIT: Below JQL not working as well.

      assignee = currentUser() AND assignee = userid1 AND assignee = userid2 AND statusCategory = Done order by updated DESC

Please note, in a restricted environment I may not able to use Plugins.

One line requirement: I'm trying to get the number of tickets assigned to each team members (e.g. 10 team members out of large 100 members) and how many tickets they resolved in any given month( lets say, Dec 2021)

Thanks.

Upvotes: 1

Views: 11129

Answers (1)

Graziella Iezzi
Graziella Iezzi

Reputation: 46

Depending what Jira are you using Cloud or Software, and if you use any add-on, you may have a different set of options in the JQL and in the Gadgets, what I'm mentioning below works in both types of Jira without add-ons.

You can create different filters with your JQL to track the different times (My closed tickets last week, My closed tickets last month, etc)

e.g. if you add one of the following to your JQL

  • AND resolved >= startOfWeek() you will have the tickets set to done in the current week (starting from this past Monday)
  • AND resolved >= startOfWeek(-1) you will have the tickets set to done from last week (starting from its Monday) and the current week

You can use startOfMonth() or startOfYear() in the same way, and of course you can play with the operators to get and exact week, month or year if you wish. Or you can use resolved > -1wwhich gives you exactly the last 7 days. You can find additional examples here

Let's say I save this JQL as "My closed tickets last week" assignee = currentUser() AND statusCategory = Done AND AND resolved >= startOfWeek(-1) AND resolved < startOfWeek() order by updated DESC to get only the tickets resolved last week

Now you can't get the amount of tickets from the JQL itself, I mean you can run the filter and see the amount of tickets it returns. I'm assuming you want to have a place where you see at once the amount of tickets closed last week, last month or last year all together. What you can do is grouping those tickets in Gadgets in a Dashboard.

Unfortunately Jira doesn't have a wide range of reporting tools, so if you don't use any add-on you will have to settle for what you have available.

Once you saved your filter, you can follow the instructions here if you are not familiar with it You can go to your Dashboard normally here https://<your Jira URL>/secure/Dashboard.jspa and add one of these gadgets that would give you the total count of tickets based on the filter:

  • Issue Statistic, if you set it up like this enter image description here it will show this enter image description here
  • Two Dimensional Filter Statistic, if you set it up like this enter image description here it will show this enter image description here
  • Pie Chart, if you set it up like this enter image description here it will show this enter image description here

They are not ideal, but they give you a number you can looks at, you can have multiple of them for each filter you create, and use the same for other statuses as well, and you can adjust them in case you need to create these sort of reports including multiple people not just like yourself.

If having add-ons is an option for you EazyBI is made to cope with the lack of reporting features in Jira. It has reports of any sort, but the learning curve can be medium/high. Once you create your reports there, you can show them in a Jira Dashboard as well as other Gadgets.

Upvotes: 2

Related Questions