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?
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.
Just a count of issues per assignee each month.
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.
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.
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.
It looks like you're new here. Sign in or register to get started.
