nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating a jira report that shows past assignees

Gaurav Agarwal_91rvjx

Hi - I have a JIRA reporting question.

We follow a flow where developer works on a ticket and then assigns to QA for testing and eventual release.

Now I want to find out workload report for developer post sprint completion, except that the assignees have changed (all QA now).

So I wrote a report with "was" operator. My query is something like this:

project = P and sprint = 1 and status was in (foo, bar) and assignee was in (a, b, c, d)

Now I can get the list of all the issues except that their assignees are the latest assignees. Is there a way to group issues by the assignee at the time (and show the assignee in that state)?

Is there a better way to solve the problem?

Accepted answers

All comments

Tarun Sapra

Hello Gaurav,

I had similar requirements and I use Arsenale Dataplane reporting plugin.

Tarun Sapra

See this chart , something you mighr find interesting- http://www.arsenalesystems.com/docs/display/dataplane/Issue+Values+by+Date+Report

Andreia Filipa Fernandes

Hello,

The best add-on for that is AIO Reports. You can export all the history values for any field (even custom one's)

Tomasz Kustrzynski

You can also try Advanced Export if using JIRA Cloud: https://marketplace.atlassian.com/plugins/com.sngtec.jira.cloud.exporter/cloud/overview

Tom_7j47w7

Hi @Andreia Filipa Fernandes,

do you have some more advice or link to documentation on how to do that? I am pretty new to AIO and could not find what you described so far.

Thanks.

Tom_7j47w7

To be more precise I'd like to have report on assignees to a ticket that did not track time on that ticket.

James Chan_y5kcz8

Love that day report feature! wish it will also be available for the JIRA Cloud version in the future as well....and for SMB like <50 seats...

Aron Gombas _Midori_

You can export the whole change history of your issue to Excel like this:

Then you could create a pivot table from the data and filter it only to the changes of the Assignee field. Then you can fine tune the dimensions of the pivot table.

(The export can be created with Better Excel Exporter, an app developed by my team.)

Andreia Filipa Fernandes

Hello @Tom ,

you have a custom field named "history" where the value should be "assignee". Then, choose you should have the history start value and the history end value to give you the transitions that were made on that field. Hope it helps.