How to show spent time from each column?

[Cristiane Gonçalves]

Hi, 

How to show in a graph or report  what total time/days  that issue spent in each column/phase? 

I have iniciated in Jira recently. 

Thanks for advance.

Cris

[Cristiane Gonçalves]

Thanks for everyone that replied my question. Thank you very much!

[Amay Purohit_RVS]

Hi @Cristiane Gonçalves 

Welcome to the community !!

You can use Jira Rest API's to build your own custom solution and track time spent by your issues in each status. For a readymade solution, a mktplace app can help here. If you are open to try out one, do take a look at

Time in Status Reports 

One of the many reports which the app provides is Time in Status in hours/days to determine , how much time the issue spent in each status in the complete lifecycle of the issue. 

The app has 20+ reports to meet a variety of time in status use cases.

More Details here 

Disclaimer : I work for the vendor who built this app

[Trudy Claspill]

Hello @Cristiane Gonçalves 

Welcome to the Atlassian community.

Jira does not natively provide such a report. Are you willing to get a third party app to get that report?

[Trudy Claspill]

@Cristiane Gonçalves 

After my first response you asked how you can get the information via JQL.

If you are not willing to use a third party app you would have to do extensive customization in each project where you want to get the information l. You would have to create custom fields for each column to record the amount of time an issues was in that column. You would have to create Automation Rules or use another programmatic method to calculate the values  and insert them into those fields. Then you would be able to include those fields in the output of filters

There is no built in method to get that information otherwise.

[Hannes Obweger - JXL for Jira]

Hi @Cristiane Gonçalves,

welcome to the community!

As already suggested, this is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their status time reporting needs. 

If a Marketplace app is an option for you, I think you might like the app that my team and I are working on, JXL for Jira. 

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields - including all JSM-specific fields - much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren’t natively available, including time in [status], time between [status] and [status], and many, many more.

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. Of course, you can also export your data to e.g. Excel or Google Sheets in just one click.

You may already know that you can trial any app for free for 1 month, so if an app is an option for you, perhaps try a few and see which one works best for you and your team!

Any questions just let me know,

Best,

Hannes

[Gizem Gökçe _OBSS_]

Hello @Cristiane Gonçalves ,

Welcome to the community!

There is no built in solution in Jira for this. So in order to track the time spent on each status I suggest you use a marketplace app. Timepiece - Time in Status for Jira ,the oldest and leading "Time in Status" app in Atlassian Marketplace, which is developed by my team at OBSS, has a report type that will meet your need.  Our app is available for both Jira Cloud, and Data Center. 

Timepiece mainly allows you to see how much time each issue spent on each status or each assignee. 

Status Duration report (please see the screenshot above) which shows how much time each issue spent on each status. You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

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.

Tiimepiece 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. And the app has a REST API so you can get the reports from Jira UI or via REST. Also you can export the reports in to various formats easily. 

Visit Timepiece - Time in Status for Jira to explore how our JIRA add-on can revolutionize your metrics measurement process. Enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

[Mehmet A _Bloompeak_]

Hi @Cristiane Gonçalves

Welcome to the Atlassian Community!

There is no built-in solution for time in status info in Jira. You can try  Status Time Reports Free app developed by our team. It is completely free and the limited version of Status Time Reports app.

This app mainly provides reports and gadgets based on how much time passed in each status. It also has a dynamic status grouping feature so that you can generate various valuable reports as cycle time and lead time, time in status, time in assignee, status entry dates and status counts, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Time in Status for Each Issue report.

For further details, you can have a look at Status Time Reports How to Videos.

App Features:

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. 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.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

If you have any questions, feel free to schedule a demo with us.

Hope it helps.

[Iryna Komarnitska_SaaSJet_]

Hi @Cristiane Gonçalves ,

If you don't mind third-party apps, I recommend the Time in Status app, developed by my team.

The board column is equal to the concept of Issue Status. Therefore, you need a regular Time in Status report.

In addition, the app has other types of reports: Assignee Time, Average Time, Status Entrance Date, Status Count, Transition Count, Time in Status per Date. And the ability to display them as gadgets on the Jira Dashboard. Create pivot tables.

For you - 30 days of trial, and if you have any questions and do not know how to implement the app in your workflow, you can book a demo call where we will be happy to help you.

[Danut M _StonikByte_]

Hi @Cristiane Gonçalves,

Jira does not offer such report. But you could try using the WIP Aging Chart gadget offered by our Great Gadgets app.

It splays the issues from a board by their current board column or status (x axis) and their age (time in that column or status).

The gadget offers a detailed report with all the issue and time in their current column or status.

 

See also https://community.atlassian.com/t5/Jira-articles/Building-a-powerful-Kanban-dashboard-in-Jira-with-Great-Gadgets/ba-p/1664331

This app has a 1-month free trial. If you have any questions, please contact us at support@stonikbyte.com.

Hope this helps. 

Danut.

[Cristiane Gonçalves]

Hi, thanks for answer, 

How can I get this value from jql or other way?

time spent in each column 

Thanks