nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Renjith Pillai

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

All comments

Bhushan Nagaraj2

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.

Bhushan Nagaraj2

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

Renjith Pillai

Rumceisz

Hi Renjith,

that's look cool!!

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

Thanks

Andriy Zhdanov

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

Jeannette Lamb

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

report

status

time

time-spent