dwalby Posted April 25, 2019 Share Posted April 25, 2019 Hi all, Is there a way to create a report that shows the total amount of time a request has been open for? Thanks in advance Link to comment Share on other sites More sharing options...
Victor Posted April 25, 2019 Share Posted April 25, 2019 @dwalby can you define "open" please (for example, not sure if you want to exclude the time it was on hold) Link to comment Share on other sites More sharing options...
dwalby Posted April 25, 2019 Author Share Posted April 25, 2019 @Victor - yes sorry, including on-hold Link to comment Share on other sites More sharing options...
Victor Posted April 25, 2019 Share Posted April 25, 2019 @dwalby ..ok... so from the date/time it was raised until the date/time it was closed? or until was resolved? Link to comment Share on other sites More sharing options...
dwalby Posted April 25, 2019 Author Share Posted April 25, 2019 Resolved Link to comment Share on other sites More sharing options...
Victor Posted April 25, 2019 Share Posted April 25, 2019 @dwalby ok then, you could use this field from requests table: However, this will give you the time in seconds, not sure it is a format you would find useable... Link to comment Share on other sites More sharing options...
Deen Posted April 25, 2019 Share Posted April 25, 2019 h_fixtime (Request Resolve Time) may also come in handy for this report. Link to comment Share on other sites More sharing options...
Victor Posted April 25, 2019 Share Posted April 25, 2019 @Deen @dwalby - actually yeah, is the Request Resolve Time that gives the time it took to resolve the request, not the Request Resolve Seconds (which is the time request needs to be resolved by). So, scratch my above reply, and use Request Resolve Time 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