Using API values in Zendesk Explore formulas is crucial because UI values won't return results.
The Changes - Previous value and Changes - New value attributes specifically require API values. These values are found in a JSON file accessed via the ticket field's ID. Using the correct API value ensures your formula is valid and returns the expected results. For example, 'Advanced Support' might be the UI value, but 'advanced_support' is the API value needed for the formula.
For further details, check the originalZendesk help article.
The reason your report doesn't return results is that the Changes - Previous value and Changes - New value attributes require the API value of a field, not the UI value. To find the correct API value, you need to locate the ID of the ticket field…
To find the API value for a ticket field, you need to access the JSON file for that field using its ID. First, locate the ID of the ticket field by navigating to Admin Center, clicking the Objects and rules icon, and selecting Tickets > Fields….
To use the Changes - Previous/New value attribute correctly, you need to use the API value of the field, not the UI value. Start by finding the ID of the ticket field you want to report on in the Admin Center under Tickets > Fields. Use this ID in…