Recent searches

No recent searches

How to create one metric where 2 metrics are true

Answered
image avatar

Abby

Posted Jul 03, 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 comment

Date
    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

    Please sign in to leave a comment.

    Didn't find what you're looking for?

    New post