Same Day Closure %

Hello,

 

I am working on a way to figure out what the same-day closure rate % is for customer support cases created within X time frame. As well as compare that to a previous time frame. 

 

 

Example: 

Feb 2017 = 73%

Feb 2018 = 90%

 

March 2017 = 85%

March 2018 = 88%

 

I would like to see if there is a visual way of doing this as well as a straight number. 

 

The time format for case opened and closed is: 2018-08-22 09:36:09

Any assistance is greatly appreciated.

Tagged:

Comments

  • Hello,

     

    You can use a beastmode in conjunction with a period over period chart. Below is an example of how the beastmode would look for percent of cases closed within seven days. Then I would use the Bar line period over period chart, select my time period to be CreatedDate and then my Y Axis to be the beastmode calculation. 

     

    COUNT(CASE WHEN DATEDIFF(`CloseDate`,`CreatedDate`) <= 7 THEN `Id` END)
    /
    COUNT(`Id`)

    Then after that is complete I go to my date range, choose last 13 months, graph by month and then pick how many months back I want compare to, in this case previous year so 12. Please checkout the attached image for more detail.

     

    Hope this helps,

     

    Brian

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!