Creating calculated metric with ticket custom field

5 コメント

  • 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
  • Taline Moroyan

    Hi, 

    I used the formulas here and I noticed that the calculated custom metric is providing 1 and 0 values. Is there a way to filter the metric to show 1 only. 

    0
  • Graeme Carmichael
    Community Moderator

    Taline

    Have a look at the metric filter article here.

    Hope that helps 

    0
  • Taline Moroyan

    Hi Graeme, 

    That helps. Thank you!

    Taline

    0

サインインしてコメントを残してください。

Powered by Zendesk