SUM issue

4 댓글

  • Andrei Kamarouski
    Community Moderator

    Hi Jasper Visser (Embrace)

    Could you show what formula do you use for this metric? 

    0
  • Jasper V.

    Andrei, 

    Yes, sure. It consists of 3 parts. What you see in te above example is this one  

    IF (SUM(Opgelost binnen SLA) = 1) THEN 1 ELSE NULL ENDIF

    Where "Opgelost binnen SLA" is calculated by a switch:

    SWITCH ([Ticketprioriteit]) {
    CASE "Urgent": IF (SUM(Netto oplostijd binnen werktijden) < 4) THEN
    1
    ELSE
    0
    ENDIF
    CASE "High": IF (SUM(Netto oplostijd binnen werktijden) < 12) THEN
    1
    ELSE
    0
    ENDIF
    CASE "Normal": IF (SUM(Netto oplostijd binnen werktijden) < 40) THEN
    1
    ELSE
    0
    ENDIF
    CASE "Low": IF (SUM(Netto oplostijd binnen werktijden) < 160) THEN
    1
    ELSE
    0
    ENDIF
    }

    This switch uses another custom metric "Netto oplostijd binnen werktijden" which is a calculation of default metrics: 

    SUM(Full resolution time - Business hours (hrs)) -
    SUM(Agent wait time - Business hours (hrs)) -
    SUM(On-hold time - Business hours (hrs)) -
    SUM(First reply time - Business hours (hrs))

     

     

    0
  • Jasper V.

    i've managed to solve this by keeping the Ticket-ID as a Row. Then i've added totals via Result Manipulation. This gives a correct calculation. This calculation is then used in a pie-chart. 

    0
  • Andrei Kamarouski
    Community Moderator

    Great to know Jasper V.

    I usually build testing reports to find the initial metric where it doesn't calculate properly. Have not even started on my end to check this - and you solved it already. :) 

    0

댓글을 남기려면 로그인하세요.

Zendesk 제공