Hi,
I have a challenge for you
Does anyone know an add-on with which I can measure how long a task has a certain status in a custom field?
e.g. An IT ticket has a custom field with status and I want to measure for how long the status was “In progress/solving”.
Something like this is possible in JIRA and I am sure there should be a solution out there.
@paulminors did you have this issue perhaps before?
Best,
Sebastian
I bet you could do this with the API!
I wonder if you can do something like this in Zapier.
e.g.
- When custom field changes to “In Progress” update another field to the start date.
- Once a day, look at the start date/time and work out the difference from the current date/time.
- Then update another field to show “time in progress”.
It’s not an elegant solution, but that’s where I would start to have a play.
1 Like
@Mark_Hudson Didn’t you mention in a post that you do this?
Hi Jason. I’m flattered that you feel I have the technical skill to do this!
No, we use a very basic custom field to track the time spent on a task - colleagues input an estimate, rounded up to the nearest hour. It sounds like Sebastian’s after something more automated and precise.
I bet @LenSantos would have a way to solve this.
1 Like
@Sebastian_Paasch,
I don’t know of any add-on. However @Alexis is correct. This can definitely be done using the API but of course you will still have to code it.
- Get all tasks with the specific status in the custom field
- Check each and every story of each task which has the date and time the custom field was updated to the current status
- Aging = current date and time - story date and time
If story is not available: Aging = current date and time - task creation date and time
However, there’s a flaw in this logic. The story might not be available because it was deleted by the same person who updated the status.
2 Likes