Time to Resolution cases

We have been waiting for the opportunity to capture case duration. After upgrading to 9.1 on cloud, we found ourselves with the Resolution Date already in the Cases record view, so users began using it, up until case wouldn't close and the resulting error message referred to something like, "cannot be resolved before created." 

So now, we can capture duration, but the problem exists where users must create cases in real-time. For our needs, sometimes a case is created after the fact because it was a weekend call, they were onsite and an issue came up, too much going on - so the case was created later / solved later. 

Because the system timestamps the Date Created and uses that against the Resolution Date / time to establish the total time spent on the case, we are looking to make this work for us, while still maintaining a level of flexibility about delaying a case's creation, but accurately depicting its duration. 

 I did find this, but it will give the same problems (must create the case in real-time) 

https://support.sugarcrm.com/Knowledge_Base/Workflows/Capturing_Case_Close_Date_and_Time_to_Resolution/index.html 

We may be out of luck on this one, or just have to have some cases outside the norm. Any thoughts or help would be appreciated!

Parents
  • Hi Missy Brooks,

    This is a great question, and how it is approached depends on how you envision your system working.

    I understand the scenario of cases being made after they are resolved, and you still needing to capture the amount of time they took to resolve even though the entire duration of the case predates the case record's existence.

    You are also correct that the core functionality of the Resolution Field is to validate that it is after the Date Created.

    Are you using a different field other than Date Created to calculate the case's duration against the Resolution Date? If so, would disabling the validation on the Resolution Date field fulfill your need?

    Doing so will require custom code. I am asking just to get a sense of the potential solution that would serve your need in this described issue.

  • Hi Patrick McQueen,

    We are not. We have always used only a field named "Duration" that users manually populated with a total number of hours, days or weeks. I have hidden the "Resolved Date" on the record view for now because of the issue with Cases not closing that I mentioned. But would like to be able to utilize it - and also begin capturing duration automatically as well, according to the workflow capability mentioned in the document link (if either is possible). 

Reply Children
No Data