check assignee in the past

CESAR DALDOSSO_b2zh72

Hello, I have a board with the following collumns 
TO DO | IN PROGRESS | TO TEST | IN TEST | COMPLETED

Over this process, a worker gets assigned to the issue when it goes in progress, however after going to test and remaining transitions, it is always unassigned.

Is it possible to query the number of tickets that this worker pulled from TO DO to IN PROGRESS  , I mean, in the past ? 

Tracy Chow_f2gtzj

Hi Cesar,

Yes, that is possible to query in Atlassian Analytics.

The Jira "Issue status history" table contains the status history of a Jira issue and you can also use the "Author account ID" column to identify which user changed the status of the issue.

You can query the Jira "Issue history" table where "Field name" = 'Assignee' to get the assignee history of a Jira issue.

Tracy