How can I show the YTD tickets for each of the assignees?

[Gary Bray]

I use this JQL to show the MTD tickets for our team: 

resolved >= startOfMonth(-1m) AND "Team[Team]" = 8984f213-05af-40b4-ad99-415bc5d12e78

How can I show the YTD tickets for each of the assignees?

[Trudy Claspill]

Hello @Gary Bray 

There is a startOfYear() function comparable to the startOfMonth() function.

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfYear--

Do you want to present the output as a list of issues per Assignee or a count of issues per Assignee?

If you want a list, you can add the clause ORDER BY Assignee ASC to the end of the filter to sort the issues based on the Assignee.

If you want to show a count, then you can use the filter as input to the the Two Dimensional Filter Statistics gadget on a Jira Dashboard and set Assignee as one axis of the gadget.

[Gary Bray]

Just a count of issues per assignee each month.

[Trudy Claspill]

The short answer is there is not a native JQL or dashboard report for what you are trying to achieve. But there may still be native options for getting the data. Or you can consider a third party app that provides more complex data analysis and reporting capabilities.

We need a more detailed explanation of what you are trying to accomplish.

Can you start by telling us what problem you are trying to solve by getting this report? How will you use the information in the report to make decisions or changes?

The Assignee on an issue might be different people within a given month. Would you want the issue to be counted multiple times in that month, attributing it to every person to whom it was assigned in that month? If you wanted each issue counted only once for a given month, on what day of the month do you want to get the Assignee value?

What do you want to do with the data? Are you hoping to present it in a Jira dashboard?

Does it matter what the status of the issue is? For instance, if the issue is "done" should it keep getting counted in each month?

One potential work around if you want to count each issue only once in a month and attribute it only to the Assignee specified at the end of the month is to construct an Automation rule that will run on a schedule on the last day of each month to get all the issues that have an Assignee value. There are steps that can be taken within the Automation Rule to count the number of issues per unique Assignee, and you could send yourself the results via email. Each month you would get the information for the past month, and you could compile that in the spreadsheet tool of your choice.

[Gary Bray]

I've configured it to show YTD tickets by assignee like this.  But I would like to break down how many each assignee records per month too.

[Gary Bray]

I'm really just trying to illustrate how many tickets each member of our team closed per month during the given year.  Right now I'm just saving the numbers into an Excel spreadsheet located on my desktop and that's a REAL pain!

[Trudy Claspill]

Thank you for that additional information.

Without using a third party app there is not a native report/gadget to get what you want.

You could potentially create a custom solution thus:

1. Create a custom field to note the month in which an issue was "closed". This would need to be a selection list type of field.

2. Create an Automation Rule (or it might be possible to do in a workflow Post Function) to populate that field when an issue is closed.

3. With Automation Rules (or workflow Post Function) make sure that field gets cleared if the issue gets reopened.

You could then create a filter to retrieve the issues of interest (i.e. resolutiondate >= startOfYear() ) and then use the Two Dimensional Filter Results gadget to present the numeric data. You would set one axis to the Assignee field and the other access to the custom field in which you noted the month the issue was closed.

[Alexey Pavlenko _App Developer_]

Hi @Gary Bray ,

Do you use sprints? If so, for the visualization you shared, but for months, you can use the app I developed - Multi-team Scrum Metrics & Retrospective.

If you don't use sprints, but like the view below I can implement the same without sprints in the app in a couple days for you. Contact me via this form or email in this case.

With the app, you will be able to view the details of each bar in the same view and drill-down to the period below. In this case it's sprints:

Or you can choose any other period to display - years/half-years/quarters/months/sprints:

Best regards,
Alexey

[Danut M _StonikByte_]

Hi @Gary Bray,

To obtain "a count of issues per assignee each month" you need a plugin because Jira's native gadgets cannot display this.

In case you want to use a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget that display this very easy in form of table, heatmap table or chart of various types.

In case you want to give it a try, this is how the gadget should be configured:

 

Also, on More Settings tab you must choose to extract month from Resolved field by setting Resolved = "MM".

If you have any questions, feel free to contact us at support@stonikbyte.com. 

Danut.