Automation to control time in eache status

[Eduardo Bentes Carneiro]

I want to make a automation to tell me how many minutes my team spent in ench status.

It will basically work like:

When issue is transitioned of one status for another one then tell me the time spent in that status

Any ideas

[Danut M _StonikByte_]

Hi @Eduardo Bentes Carneiro,

I'm not sure if it's possible to do this for each workflow status via automation, because this would require a lot of custom fields and complicated calculations... And what if an issue has gone through a status multiple times?!

A much easier solution would be to use a plugin from Atlassian Marketplace that is capable to make this type of calculations.

In case you want to try a plugin, our Great Gadgets app offers a Time in Status gadget that can calculate and display this for you with just a few clicks. 

Beside the chart, it can display a Data tab with a report showing the time spent by each issue in every status, which you can easily export in CSV.

Danut

[Sebastian Krzewiński]

Hi @Eduardo Bentes Carneiro 

But why? :D I have many examples how this idea didn't work for any report.

Answering your question: You will need 2 field (one for moment when ticket enter status and another one for when leave status). Then you can make a calculation with smart values (https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-difference---). Rule can work like below:

- triggered by status change

- set leave status field

- make calculation

- set enter status field for new status

Regards,

Seba