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

[Laurie Taisey]

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]

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.

[Laurie Taisey]

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

[David Friedrich]

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".