Total Request Open Time Report

[dwalby]

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]

@dwalby can you define "open" please (for example, not sure if you want to exclude the time it was on hold)

[dwalby]

@Victor - yes sorry, including on-hold

[Victor]

@dwalby ..ok... so from the date/time it was raised until the date/time it was closed? or until was resolved?

[dwalby]

Resolved

[Victor]

@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]

h_fixtime (Request Resolve Time) may also come in handy for this report.

[Victor]

@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