Creating calculated metric with ticket custom field

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:

• Converting a numeric field metric into an attribute

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:

• Creating standard calculated metrics and attributes

I hope this helps!

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

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. 

Taline

Have a look at the metric filter article here.

Hope that helps 

Hi Graeme, 

That helps. Thank you!

Taline