Report to Show Any Tickets Open Longer than 2 Weeks

kathryn.wells

We are looking to create a report that provides a daily count of tickets that have been open for at least 2 weeks. (The status can be "Waiting for Support", "Waiting on Customer", "Waiting on Technician" or "Hold".) I was looking through community, and I found this: https://community.atlassian.com/t5/Jira-questions/Reporting-on-Open-Unresolved-Ticket-but-Also-Closed-in-the-Last/qaq-p/1147685 

I'm looking to build a similar report, but our HR manager is not interested in having closed/resolved tickets included in this report. 

Any thoughts on what I could add to our filter within our series? We have tickets that have been on hold for a couple of months, and I would like to have these tickets appearing each day on the report until they are resolved.

Jack Brickey

try this to start...

1. create and save this filter (tweak as necessary) - createddate <= startOfDay("-2w") and status in ("Waiting for Support", "Waiting on Customer", "Waiting on Technician", "Hold")
2. create a subscription that runs daily for this filter

note: you may wish to simplify the filter moving away from the status and instead use the Resolution field, e.g. ...and Resolution is EMPTY