Recent searches
No recent searches
DATE_DIFF() should return only time differences within business hours
Posted Feb 12, 2018
Hi Zendesk Team
At creating a calculated metric in Explore, there should be a functionality for calculating the time difference within business hours.
DATE_DIFF() does not give an option to consider business hours or not.
This would be a nice feature.
Thanks
Daniela
17
12
12 comments
Nayeli G. Jimenez
Hello Zendesk team.
About this comment by Daniela, is any change? Is important for specifics metrics, that we can consider business hours or not, in Date_Diff function, or something to discriminate just saturday and sunday.
Thanks for the reply
2
Ryan Mumby
Also just went through a nightmare of trying to use a whole mess of different standard and custom attributes to come up with my own "first assignment to resolution time" metric that would only show business hours only to ultimately end up not being able to calculate date diff in business hours in every avenue I went down. Can't believe this isn't available, feels like it would be pretty simple to code as there are a bunch of other standard metrics that make that calculation behind the scenes, its just not available in the GUI for us to grab and use on our own.
2
Matt Farrington-Smith
Hey Ryan Mumby on the off chance you see this - what did you end up doing?
I have a similar situation and ZD even told me it's not possible. If this know this then why!?
2
Ivonne Benitez
Hello Zendesk team!
Any updates or possibility that this is on your roadmap?
2
Nayeli G. Jimenez
Hello Zendesk team.
Any update or guide to make this possible?
Thanks
2
洋一 安部
Hello, Zendesk team.
Me too. It's also intense mess to us.
We can't measure our performance correctly.
We eager to ZD would add it to the ticket metrics or calcurations.
4
Sara Ledger
This is also very important to our organization as we have different groups using different schedules. Needing to know the time frames between dates based on the schedule set on the ticket is very important.
4
Quinn McHugh
This is a blocker for my organization - not being able to calculate date differences based on a business calendar means we are not able to accurately report on the SLAs we've defined.
3
Justin Rogers [.io]
Yes this is a big blocker for my organization as well to the point where we had to change SLAs. This is an industry standard measure of SLA that baffles me Zendesk cannot provide analytics for, unless the Support Department is 24 hours.
1
Sanket Tambadkar
Hello Zendesk team.
Any update or guide to make this possible?
Thanks
1
Wojciech Smajda
Hello,
Appreciating your suggestion for a business hours consideration in the DATE_DIFF() function within calculated metrics in Zendesk Explore.
We realize the importance of such a feature to accurately reflect time differences according to specific business hours. While our current functionality aims to be as versatile as possible to accommodate various business models, we acknowledge that it may not fully meet every unique requirement.
Your feedback is important to us and has been noted. Should interest in this feature grow within our community, it will help us prioritize our development efforts accordingly. At this stage, there are no immediate plans to implement this request.
Thank you for your understanding and for helping us improve Zendesk.
0
Jacqui T
Businesses: Hi, we're a business, using your software designed for businesses, and we'd like to do some reporting based on business days only
Zendesk: Hmm, I dunno, sounds like a bit of a unique requirement to me
0