Filter query for cummulative time in status

Gareth Bristow December 1, 2014

I'm trying to run SLA reports, and I require a way to report on issues which have been in, for example, "Status 1, Status 2" > 2d. This needs to be cummulative, as the statuses change frequently as issues are moved between departments. I'm trying to drill down and find the bottlenecks.

Is there any way to do this with filter queries? I've found the "WAS IN" query, but it doesn't have a "FOR" predicate.

Thanks in advance smile

1 answer

1 vote
Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 1, 2014
Gareth Bristow December 2, 2014

Good suggestion, but this only allows me to see average time in each status. I need to be able to see the time in status of each issue.

Suggest an answer

Log in or Sign up to answer