Skip to main content
Solved

Historical Reporting - Inbound and Email - Service Level Calculations

  • August 3, 2022
  • 1 reply
  • 91 views
K
Do Gooder (Partner)
Forum|alt.badge.img+1

We know how to get the data into a report but how do we write customer calculations based on the data we have pulled from the global action sets and then manipulate it to form specific variables such as counts and percentages?

An example would be: If a customer queue time is >1 and agent active time for the specific call = 0 (or Null) then add one to an int variable called “Abandoned”. 

 

We would then want to report on the above variable “Abandoned” and use it in further calculations to work out SLA. 

Best answer by TerryWalters

Hi Kenosha,

In order to calculate a custom field value the selections that will make up the calculation must first be included in order to populate the field list in the Custom Fields definition - these fields do not need to be used in the output, however the usual T-SQL rules around grouping of selected columns will apply.

 

For your specific case, you can use two different ways to assign the “Abandoned” value to each record.

You may use the CASE function, or the IIF function - examples of both options are below.

 

CASE

CASE WHEN (Inbound_sys_INBOUND_CALL_RING_TIME >= 1 AND (Inbound_sys_INBOUND_CONNECTED_CALL_DURATION = 0 OR Inbound_sys_INBOUND_CONNECTED_CALL_DURATION IS NULL)) THEN 1 ELSE 0 END

 

IIF

IIF((Inbound_sys_INBOUND_CALL_RING_TIME >= 1 AND (Inbound_sys_INBOUND_CONNECTED_CALL_DURATION = 0 OR Inbound_sys_INBOUND_CONNECTED_CALL_DURATION IS NULL)),1,0)

 

 

View original
    Did this topic help you find an answer to your question?

    1 reply

    TerryWalters
    Do Gooder (Employee)
    Forum|alt.badge.img+1
    • TerryWalters
    • Do Gooder (Employee)
    • 2 replies
    • Answer
    • August 3, 2022

    Hi Kenosha,

    In order to calculate a custom field value the selections that will make up the calculation must first be included in order to populate the field list in the Custom Fields definition - these fields do not need to be used in the output, however the usual T-SQL rules around grouping of selected columns will apply.

     

    For your specific case, you can use two different ways to assign the “Abandoned” value to each record.

    You may use the CASE function, or the IIF function - examples of both options are below.

     

    CASE

    CASE WHEN (Inbound_sys_INBOUND_CALL_RING_TIME >= 1 AND (Inbound_sys_INBOUND_CONNECTED_CALL_DURATION = 0 OR Inbound_sys_INBOUND_CONNECTED_CALL_DURATION IS NULL)) THEN 1 ELSE 0 END

     

    IIF

    IIF((Inbound_sys_INBOUND_CALL_RING_TIME >= 1 AND (Inbound_sys_INBOUND_CONNECTED_CALL_DURATION = 0 OR Inbound_sys_INBOUND_CONNECTED_CALL_DURATION IS NULL)),1,0)

     

     

    J
    1 person likes this
    • J
      Joshua Youngman

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings