Automation | Log Work | Time Spent in Status - Can I track time in progress?

[Riley Hosking]

Hi all,

I know there are apps that can do this, but I was wondering what the best way would be to track the time issues spend in the In Progress status?

I have tried with the following JQL in the Time Spent field in the Log Work automation function:

{{issue.timeInStatus("In Progress").minutes}}m

But this gives the following error in the audit log:

Error trying to log work against an issue

Worklog must not be null., Invalid time duration entered. (timeLogged)

I have {{now}} in the Date Started field.

Any suggestions?

Thanks

[Tharaka_Hettiarachchi · Accepted solution]

Hi @Riley Hosking ,

Do you want to get the logged time? Please watch this Retrieve logged time 

Cheers!

[Riley Hosking]

Hi @Tharaka_Hettiarachchi ,

Thanks for your response but unfortunately not. I want to automatically track how long it takes my team to do various issue types from a finance service desk, and then ultimately capture that on a dashboard gadget.

Any thoughts?

Cheers,

Riley

[Tharaka_Hettiarachchi]

If you want the time ona specific status you can do like this.

1. Create a custom field 

Settings -> Issues -> Custom Field -> Create Custom Field -> Choose 'Date and Time Picker' (Eg: Time In Progress) -> and add that field to your project

2. Create one automation rule to update 'Time In Progress' (It should trigger when the task transition to 'In progress'

3. Create another automation rule which will trigger when the task transitioned FROM in Progress

here the 'Time in Done' is my custom field

Cheers!