Can you set up a filter to measure time spent in a workflow?

Question

We have several works flows - these are assignments brought in for writing and editing content.  We have sla's - three days to edit content and 5 days to writing content.

There are four workflows:

1.  Selected for Editorial

2.  Editorial in Progress

3.  Editorial in Review

4.  Editorial Done

We would like to measure how long these assignments stay in Editorial in Review - this content is in review with the stakeholders.  Can a filter be applied to this workflow?

David Friedrich · Answer

Sure: project = ABC AND status = "Editorial in Review" AND updated > "2018/5/7 22:00" AND updated < "2018/5/8 22:00" gives you all tickets updated in between a fixed date. For dynamic dates , you can do something like this project = ABC AND status = "Editorial in Review" AND updated > startOfDay("-1h") AND updated < startOfDay("+6h") This will give you tickets for every day updated between 11 pm (last day) and 6 am (of current day). Hope that helps. You can also refer to many other examples here in the community. Just search for something like "jql date filter".

Laurie Taisey · Answer

yes status!  Can you give me a Jira sample filter that I could place dates in?

David Friedrich · Answer

Hi Laurie,

is it possible that you mean 'status' when you speak of workflow?

If so, then you can define filters showing you tickets being in a certain status longer then... or scince... or between two dates.

What a filter can't do is to compare or handle if-than conditions etc. It will always only show you a list of tickets matching your filter criteria for the time being.