You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why is rel_date_diff so crippled?

Received Response
26
Views
4
Comments
edited Mar 7, 2018 2:42PM in Reporting & Analytics for B2C Service 4 comments

Content

We've several hundred teams all with different schedules and hours of operations. Many of the managers want us to calculate “Time to resolve” excluding Nights and weekends. But due to the crazy restrictions on rel_date_diff I can’t even time_format the field, much less do an average. And because we’ve multiple teams with multiple shifts, the entire SLA system is a no-go for us, because it applies the SLA to the contact/org instead of the profile/queue/group.

 

I found that someone had suggested improvements in the idea lab 4 years ago but it’s never been fix. Has anyone found a way around this? 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!