Ricerche recenti

Nessuna ricerca recente

How to create one metric where 2 metrics are true

Con risposta
image avatar

Abby

Data ultimo post: 03 lug 2023

I'm trying to build a report that surfaces new tickets worked by my team. I can report on public comment updates (tickets worked, metric #1) and I have a custom metric that reports on tickets that have gone from unassigned to assigned (new tickets, metric #2). How do I write a single metric to give me ticket IDs where both of these updates are true? 

1

1

1 commento

Data
    image avatar

    Salim Cheurfi

    Zendesk Customer Care

    Hi Abby, 
     
    The most straight forward way to achieve that would be to use both metrics in a new custom metric with the function AND. 
    The function AND will check if the two metrics returns are true. 
    For example : 
    IF COUNT(Public comments) >0 AND COUNT(Assignee reassignments)>0
    THEN [Update ID]
    ENDIF
     
    Best, 

    0

    Accedi per aggiungere un commento.

    Non hai trovato quello che cerchi?

    Nuovo post