Report for all tickets opened in last 12 months that were opened for longer than 2 weeks

[Brent Cox]

Is there any way to run a report on the TASK or incident table for all tickets that have been opened in the last 12 months that were opened for longer than 2 weeks? Currently I have a filter for duration greater than 14 days, but I do believe duration is only populated once a ticket is closed. I would also like to include tickets that are still active, if possible. Can this be done? 

[AndersBGS]

Hi @Brent Cox ,

Yes, but in general you either need performance analytics or a script. as you have clearly stated yourself, this is not available OOTB as the duration is not filled for tickets that are still active.