Report to show total issues resolved by Assignee - for yesterday and also month to date

Is there a way to run a report on total tickets completed for yesterday and month to date by Assignee? On a Dashboard - I managed to create 2 views using one of the pre-configured gadgets. But I can only figure out how to do it for the last day (last 24 hours) and also for the last 4 weeks. Suggestions?

1 answer

1 accepted

This widget could not be displayed.
Ivan Tovbin Community Champion Jan 25, 2018

Hi Jason, can you please clarify what do you mean by "tickets completed for yesterday and month to date". Does that mean all tickets resolved starting from the beginning of the current month until and excluding the current day?

Hi Ivan

Yes - We want to create 2 reports:

First report that displays all tickets (all issues types) resolved month to date (excluding the present day) - but grouped by Assignee.

Second report that displays all tickets (all issue types) resolved for the previous day and grouped by Assignee.

It's basically a workload grid that only shows what has been resolved for the previous day and month to date (excluding present day).

Hope that makes sense?

Ivan Tovbin Community Champion Jan 25, 2018

Now it's perfectly clear!

Ok, here's what you need to do:

1) Create and save two filters, one for issues resolved yesterday, another for issues resolved since the beginning of the month until today. Use these JQLs respectively:

resolved >= startOfDay(-1) and resolved <= endOfDay(-1) and resolution is not empty
resolved >= startOfMonth() and resolved <= endOfDay(-1) and resolution is not empty

I've added a resolution check to exclude reopened issues from the results.

2) Now that you have these filters saved make sure you share them with all relevant users or groups because by default they are only visible to the creator

3) Add two "Issue statistics" gadgets to your dashboard and configure each of them to use one of the filters you've created. Set  'Statistic type' to 'Assignee'

Done!

You are awesome Ivan!! Thank you very much! My organization just went live with Jira Service Desk a couple weeks ago and I led the implementation. There's a lot more I need to learn; so I hope that I can answer other people's questions in this community in the future as I learn more. 

Have a great day!

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

Cheers!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

223 views 1 3
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you