How to get report all assignees of an issue in particular status

siva
Contributor
September 8, 2021

Hi Team,

I want report  to see how many times the tickets are reassigned in a particular status or all the assignee assigned the issue in a particular status (status is IN PROGRESS). Can any one please help me with this how to achieve this issue.

 

Thanks,

Siva.

3 answers

2 votes
Mayur Jadhav
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 8, 2021

Hi @siva 

I am not sure that Jira have this feature.

But you can try easy BI.

There is the standard measure of “Transitions to Assignee” that can be used for this case.

The number of changes during the In Progress status is the following formula of the custom measure:

 

([Measures].[Transitions to assignee],

[Transition Status].[In Progress])

The list of assignees can be derived further with one more custom measure:

 

Generate(

  Filter([Assignee].[user].Members,

    ([Measures].[Transitions to assignee],

    [Transition Status].[In Progress])>0 OR

    ([Measures].[Transitions from assignee],

    [Transition Status].[In Progress])>0

  ),

  [Assignee].CurrentMember.Name,

  5e18dc2a31964084de7463d2ecd8c2d408f04278.png

siva
Contributor
September 8, 2021

Hi @Mayur Jadhav  thanks for your reply,

Unfortunately we don't have the  easy BI. But we had the script runner and Arsenale Data plain reports  is it possible in any of the addons

Thanks,

Siva

Stefan Salzl
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 3, 2024

@siva 

I´m kinda facing the same problem.

were you able to solve this with scriptrunner?

 

Thanks in advance.

Best

Stefan

0 votes
Emre Toptancı _OBSS_
Atlassian Partner
September 9, 2021

Hello @siva

Our team at OBSS built Time in Status app for a similar need and it is available for Jira Server, Cloud, and Data Center.

Time in Status mainly allows you to see how much time each issue spent on each status or assigned to each assignee. It also has reports that show assignee times broken down to statuses or status times broken down to assignees.

You can calculate averages and sums of those durations grouped by issue fields you select. 

tisCloud_AssigneeDurationPerStatus.png   tisCloud_StatusDurationPerAssignee.png

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

Using Time in Status you can:

  • See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
  • Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issue type.)
  • Export your data as XLS, XLSX, or CSV.
  • Access data via REST API. (for integrations)
  • Visualize data with various chart types.
  • See Time in Status reports on Jira Dashboard gadgets

https://marketplace.atlassian.com/apps/1211756/

EmreT

0 votes
Mehmet A _Bloompeak_
Atlassian Partner
September 9, 2021

Hi @siva ,

It is not possible using the built-in JQL functionalities of Jira. So we developed Status Time app for this exact need. It provides reports on how much time passed in each status, status entry dates and status count. It can also display assignee duration and assignee count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too. Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

stf-issue-screen-view-2.png

siva
Contributor
September 9, 2021

Hi @Mehmet A _Bloompeak_  thanks for the reply,

I saw that online demo link I think it shows assignee only for present status of the issue. But here I need who is assignee for previous status as well.

For example :

If issue workflow like this Open< In Progress< Verification <Resolved < Closed

Here I need who is assignee for Verification status even issue is in Resolved or Closed status. I hope  you understand my requirement please guide me how to achieve this issue.

Thanks,

Siva

Suggest an answer

Log in or Sign up to answer