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.
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I´m kinda facing the same problem.
were you able to solve this with scriptrunner?
Thanks in advance.
Best
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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:
https://marketplace.atlassian.com/apps/1211756/
EmreT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.