It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Status A to Status B time report

Hi,

I am looking for something similiar like Resolution time gadget in JIRA. The difference is, taht I would like to set manually starting and ending status, between which the time would be meassured. I am interested in monthly reporst with average time. Does anything like this exist? Thanks for any help!

9 answers

1 accepted

Unfortunately, there's nothing built into JIRA that'll give you what you asked for. But if you are open to trying out a commercial add-on for JIRA, our Arsenale Dataplane reporting plugin is for just this sort of advanced reporting when you need something other than the simple JIRA reports and gadgets.

Here's how easy it is to get what you need with Dataplane:

  1. select the Dataplane Time from Status to Status report
  2. choose your report options:
    1. select which project, issues, filter or JQL query you want to use
    2. select your dates: e.g. any arbitrary time period, Last Month, This Month, Last Quarter, Year to Date
    3. pick any starting status and ending status
  3. run the report

Tada! You get a nice chart and data table with all the stats you need, including average, max and minimum times between the two statuses. Save the report to be able to easily re-run it. And as you requested, any saved report can be added to your JIRA dashboard as a gadget.

Here's what the chart would look like on your JIRA dashboard...

And another version where I broke down the results by issue type...

In these charts the plotted line shows you the average transition time, and the light-colored "envelope" extending up and down from the plotted line shows you the max and minimum transition times found in the data for that time period so you can easily see outliers.

Thank you for your reply, that is what I was looking for!

0 votes
darylchuah Atlassian Team Dec 29, 2013

Hey Andrew

The following FAQ article will help you to fulfil your requirement:

Hi Daryl,

I know about these two plugins, but as far as I know, any of them is able to provide report I require... or am I wrong? I mean - imagine this workflow - Status A -> Status B -> Status C and I need report of time between Status A to Status C for all tickets every month

Issue History Collector is free add-on and provides report, issue tab and custom field.

Our Great Gadgets add-on offers a Cycle Trend Gadget that might be helpful for you. It uses a Jira filter as input can can be configured to calculate lead time,  cycle time or time between two statuses that you can specify. The gadget can also display a data table (report), which contains the cycle of every issue.

As I understood all solutions here for the server version. How to get the amount of time issue spent at status for Jira Cloud?

@ledonjennifer welcome to the community!

If you are using a cloud version of Jira, our app Time in status for Jira Cloud by SaaSJet may be useful for you.

At this plugin you can add or hide columns with statuses witch data you need to calculate. Also, you can use functional "status groups" for selecting columns you want to group and you'll get one column with summed data from your previously selected columns.

It generates such reports (all of them are available for export):

- the duration of time issue was at each of the statuses.

- average time in status for each issue

- the amount of transitions issue went from status to status and number of times task was in a specific status

Additionally, this app will show you: Assignee time, Status Entrance Date and Time in Status per Date.

All data from reports you can view as tables or as charts.

 

Best regards,

Anna

SaaSJet

Hi,

You can try app Time Between Statuses.  It allows set manually starting and ending status, between which the time would be measured.

Also here you can set time limits. When time limits are exceeded, it will be visually allocated for a specific issue of the project.

This report is available for export as XLSX or CSV file, which data you can analyze more detail, including calculating the average time.

I'm also looking for this, anything on this?

Hi, 

 

We sell the SQL+JQL Driver app (available for Server and Data Center) and it is very easy to build that kind of report.

As it is standard SQL you can get the exact data and with the exact format as needed.

If you are interested in it, the installation is 1-click and there is an example for time in status. So you can check if it meets your needs in a few minutes and with a few clicks.

 

Bests,

Pablo

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you