dwalby Posted April 25, 2019 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
Victor Posted April 25, 2019 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)
Victor Posted April 25, 2019 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?
Victor Posted April 25, 2019 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...
Deen Posted April 25, 2019 Posted April 25, 2019 h_fixtime (Request Resolve Time) may also come in handy for this report.
Victor Posted April 25, 2019 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
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