Hiten Posted July 10, 2023 Share Posted July 10, 2023 Hello, We are trying to produce a Report for tickets that went to 'Resolved' last month. We have several Reports that surface, 'Logged', Resolved/Closed' but we found there is an issue with the latter because when a ticket goes from Resolved > Closed, the reporting only shows 'Closed' tickets. For obvious reasons, we do not want to have to leave a ticket in 'Resolved' state until the start of a new month, in order to then report on the previous month's Resolved tickets. What we need is something that can get the number of Resolved tickets, i.e. 'touched this status. Can you please advise how to do this or if there is no current means (e.g. feature request). Thank you, Hiten Link to comment Share on other sites More sharing options...
Steve Giller Posted July 10, 2023 Share Posted July 10, 2023 h_date_closed and h_date_resolved are separate fields in h_itsm_requests, so it should be as simple as filtering on the required date field. Something like: Link to comment Share on other sites More sharing options...
Hiten Posted July 10, 2023 Author Share Posted July 10, 2023 1 hour ago, Steve Giller said: h_date_closed and h_date_resolved are separate fields in h_itsm_requests, so it should be as simple as filtering on the required date field. Something like: Hi Steve, Thank you, I will give that a try! Cheers, Hiten Link to comment Share on other sites More sharing options...
Hiten Posted July 10, 2023 Author Share Posted July 10, 2023 2 hours ago, Steve Giller said: h_date_closed and h_date_resolved are separate fields in h_itsm_requests, so it should be as simple as filtering on the required date field. Something like: Hi Steve, Thank you, I will give that a try! Cheers, Hiten Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now