How to calculate time in Status with JQL

Question

E ai pessoal, estou querendo extrair uma informação da minha base do JIRA para poder fazer alguns filtros de eficiência no excel.

De forma resumida, queria saber se consigo extrair para excel via JQL a informação de quanto tempo um determinado ticket ficou no status, ou a quanto tempo ele esta no status atual.

Sei que temos algo semelhante de forma nativa nos dashboards do JIRA como tempo médio no status.

Valeriia_Havrylenko_SaaSJet · Answer

Oi @Lucca Fernandes 👋

Infelizmente, não há como encontrá-lo com o gadget nativo, mas consegui com o complemento.

Gostaria de recomendar o complemento Time in Status for Jira por SaaSJet. Esta ferramenta permite visualizar toda a duração de um problema, desde o momento em que foi aberto até o fechamento, com o relatório Time in Status.

Você também pode baixar dados para análise posterior usando o complemento.
O complemento tem uma versão de avaliação gratuita de 30 dias e é gratuito para até 10 usuários. 
Por favor, deixe-me saber se você tem alguma coisa.

Espero que ajude 😌

Mehmet A _Bloompeak_ · Answer

Hi @Lucca Fernandes

Unfortunately, it is not possible to extract Time in Status info with built-in JQL. If you prefer using a marketplace app, you can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

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.

* This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

* 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 are looking for a completely free solution, you can try the limited version Status Time Reports Free.

Hope it helps.

Amay Purohit_RVS · Answer

Hi @Lucca Fernandes

You can use Jira Rest API to pull this data or if you are open to try out a mktplace app to get this data, you can 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. You can group your statuses to define your own issue resolution time. The app has 20+ reports to track your bottleneck Issues & Processes.

Disclaimer : I work for the vendor who built this app