I'm trying to recreate some of our Insights metrics which use custom fields but can't figure out how to do so. Does anyone know how to create a formula that does a distinct count of tickets created for a specific ticket custom field?
Our formula in Insights is:
SELECT # Tickets WHERE Ticket Group IN (Open Access) AND #Manuscript title <> - AND Test <> true
I tried following this https://support.zendesk.com/hc/en-us/articles/360047452734-Explore-recipe-Count-of-tickets-for-a-custom-ticket-field-value, but I end up with a table and not a metric.