Hi,

 

We use Creatio cases for our customer support service desk function. I am looking at having a report which will allow us to view the metrics around SLA breaches. This is a common requirement, where we can identify the cases in a given period that exceeded the SLA parameters for response time and resolution time.

 

This should contain the following detail:

  • Case
  • Account
  • Case Created Date/Time
  • Case Closed Date/Time
  • Case Response Time exceeded time
    • This should be in Hours/Mins
  • Case Resolution Time exceeded time
    • This should be in Days/Hours/Mins

The report will only show cases that have breached the SLA within the dynamically selected time period e.g. Last Month or This Week etc.

 

I am hoping that someone has already created such a report, but I have not been able to identify how to put this together within Creatio Dashboard. Note, I have just installed the PowerBI capability and have started to play with this, as an alternative reporting method.

Thanks in advance for any help

 

Mark

Like 1

Like

3 comments

+1 also needing this type of report

 

Hi!

 

You can create a list in a dashboard that would look like this:

You can add a filter for the records in the display options tab:

And to add the calculated columns for time exceeded you can go to the Pivot table settings tab and press "Add calculated field":

 

And set up a formula that would look something like this(fields used need to be present as columns in the dashboard list): 

 

Hope it helps!

 

Best regards,

Max.

Thanks so much for the reply, I had created the first bit, but was not away of the calculated field option, which allowed me to display the exceeded time. It would be nice to be able to format the time in to Days/Hours rather than just hours, but still useful.

 

thanks again

Show all comments

Hi Community,

 

When you move Case Status from "Resolved" to "Reopened" Resolution time gets updated with a new value. Is there a way we can disable this? We wanted to retain the initial value before reopening.

 

Thanks

Like 0

Like

1 comments

Hi Fulgen, 

 

You can try to use Case deadline calculation rules lookup in order to achieve such requirement: 

 

Please refer to these posts to get more information how to set it up:

 

https://academy.creatio.com/docs/user/service_tools/service_cases/case_…

 

https://academy.creatio.com/docs/user/service_tools/service_cases/case_…

 

Best Regards, 

 

Bogdan L

Show all comments