Same Day Closure %

user09188
user09188
in Archive

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

  • Property_Ninja
    Property_Ninja

    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


    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Categories