need help to create report which shows number of days between when Ticket was Opened and Closed for a particular month

[karan15]

need help to create report which shows number of days between when Ticket was Opened and Closed for a particular month 

For e.g I can see using attached query that there were 1500 tickets created and closed in Jan 2022 however can I create a report some how to show for how long each ticket was opened for ?

E.g - Ticket created on 2 Jan 2022 , closed on 4th Jan 2022 >> number of days ticket was opened for is 2 days 

Thanks 

[Saurav11]

Hello,

Create a report on metric_instance table and use the definition Create to Resolve Duration in the filter ti should give you the required report.

Please mark answer correct/helpful based on Impact.

[karan15]

thanks Saurav ill try that