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

Rumceisz October 10, 2012

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

4 answers

1 accepted

3 votes
Answer accepted
Renjith Pillai
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 12, 2012

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 October 18, 2012

Hi Renjith,

that's look cool!!

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

Thanks

0 votes
Andriy Zhdanov
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 19, 2012

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

0 votes
Bhushan Nagaraj
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 11, 2012

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

0 votes
Bhushan Nagaraj
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 10, 2012

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 October 11, 2012

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.

Suggest an answer

Log in or Sign up to answer