Monthly increase of tickets

Question

Hi,

I would like to create a filter that will show all the tickets assigned to me on a monthly basis. My objective is to document if there was an increase or decrease in workload.

What I tried so far:

Set up filter "Assigned to me" and "Create date" on a monthly basis (1st until 31st).

The problem with this filter is that JIRA then only shows me all the ticket that were created in a certain time and still are assigned to me. What I need is, all tickets created in a certain time frame assigned to me in that time frame only.

Seems to be a mission impossible.

Thank you in advance for the help.

Best,

Lukas

Ignacio Pulgar · Answer

@Lukas Korenacka Have you already found out how to do what you wanted to do?

Midori · Answer

The JIRA Better Excel Plugin can generate this report (and any other custom Excel reports) to you like this:

* Execute a JQL that returns all issues you want to include in this report
* When the issue list is passed to the Excel add-on, process the change history of each issue with a simple Groovy script* Check every change where the assignee was modified
* If this is not the current user, skip it
* Otherwise insert this into a map that contains issue-to-date mappings

* Export this mapping to Excel* Also export two computed columns, in the first use the YEAR() Excel function to derive the year when the assignment was made, and in the second use the MONTH() function

* Now you have all source data: issues, the year and the month when it was assigned to you, so you can define a simple pivot table from these
* You can even define a pivot chart to visualize the trend

This may require a little work to set up this report, but after that you can get the current report with a single click. You can even auto-email the Excel report to you at the end of each month!

Ignacio Pulgar · Answer

If you are not the current assignee of some of the issues, the operator that you need is WAS.

Try this:

assignee WAS currentUser()