Creating calculated metric with ticket custom field

2 Comentarios

  • Christophe
    Zendesk Customer Advocate

    Hi Dominic,

    In Explore, numeric fields are considered as a metric. So you would need first to convert #Manuscript title, which seems to be a numeric field, as an attribute. This article explains how to do it:

    Once you converted #Manuscript title to an attribute, we can use it to build this metric:

    IF ((([Ticket group] = "Open Access") AND ([Manuscript title] != "-" ) AND ([Test] != TRUE))) THEN [Ticket ID] ENDIF

    You can directly copy paste this metric. Here are more information about creating metrics:

    I hope this helps!

    0
  • Dominic Dixon

    Hi,

    Thanks for this. Our #Manuscript title ticket custom field is not numeric it's text (sorry should have been more specific). Is it still possible to do this using a text field? It would basically be counting all of the tickets where this field has been filled in.

    Thanks,

    Dominic

    0

Iniciar sesión para dejar un comentario.

Tecnología de Zendesk