How to get the time spent report of issues in a particular status?

[Rumceisz]

Hi All,

we have a project with more than 400 issues and we need to make a report which shows the time spent in 'Clarification' status for each issue.

How can we do that?

I know that there is the Transitions tab on the issue view but we need a report for all the issues of the project.

We use version 5.1.2 Jira

Can you please help?

Thanks in advance,

Rumi

[Renjith Pillai · Accepted solution]

Use Jamie's Script Runner Plugin, add a Scripted Field and modify and user code from https://studio.plugins.atlassian.com/wiki/display/GRV/Scripted+Fields#ScriptedFields-TotaltimethisissuehasbeenInProgress

[Rumceisz]

Hi Renjith,

that's look cool!!

And how is it work? Is there a custom field needed??

Thanks

[Jeannette Lamb]

I have a similar question, see https://answers.atlassian.com/questions/309076/script-to-calculate-time-since-created-date

[Andriy Zhdanov]

It is possible with Timesheet add-on for JIRA, using own filter. The add-on provides timesheet reports and gadgets.

[Bhushan Nagaraj]

This plugin provides a gadget to display "Average Time in Status" which may be of some use to you. But still lacks a report.

https://studio.plugins.atlassian.com/wiki/display/JCHART/JIRA+Charting+Plugin

[Bhushan Nagaraj]

Hi Rumi,

You can create a "Time Tracking Report". You have the option to export to excel and you can then filter issues in a particular status

[Rumceisz]

Hi,

you're right but most of the issues are already in a different status: so the issues concerning were/are in that particular status.