Hello!
I've just found that Analytics has a set of Business Hours/Days functions available when building custom columns. Unfortunately, these don't seem to be included within the default columns.
Has anyone altered the existing columns to include these functions? Specifically (but not limited to...):
- Time Elapsed
- Time Elapsed in Hrs
- Time to Response In Hrs
- Days Since Request Updation (?)
- Days Since Request Updation- Age Tier
- Time to Assign in Minutes
- Time to Resolve in Minutes
- Hours to Complete Since Initial Response
- Time to Resolve in Days
Additionally, have you also included exceptions for known SLA's which ignore business-days (eg. Severity 1/2 or Priority 1/2 issues)?
I feel that the existing reports that DO NOT include Business Hour considerations may be artificially inflating both response and resolution duration.
Thoughts?