Custom metric showing changes in a ticket field

Answered

6 Comments

  • Marie-Cathrine Sørensen
    Comment actions Permalink

    Hi Jessica,

    To look at group changes, you should use the group IDs instead of their names and then use [Update ID] instead of [Ticket ID]. The metric should look something like this:

    IF ([Changes - Field name] = "group_id" 
    AND [Changes - Previous value] = "insert group id of old group here"
    AND [Changes - New value] = "insert group id of new group here")
    THEN [Update ID]
    ENDIF

    For more information on this topic, you can look at this recipe: https://support.zendesk.com/hc/en-us/articles/360025454293-Explore-recipe-Tracking-ticket-assigns-across-groups

    #helpsome regards,
    Marie-Cathrine Sørensen
    Business Intelligence Analyst @ helphouse.io

    0
  • Jessica Strozyk
    Comment actions Permalink

    Hi Marie-Cathrine,

    That way it worked. Thanks a lot for your help!

     

    0
  • Jessica Strozyk
    Comment actions Permalink

    Hi Marie-Cathrine,

    Since you were such a great help last time around, I was wondering if you also know how I can access changes in custom field options. More specifically, I want to track a change in a custom ticket field from it was 'xyz' to it is 'not xyz'. I have tried different ways so far but none of them work.

     

    0
  • Marie-Cathrine Sørensen
    Comment actions Permalink

    Hi Jessica,

    Here is how I would do it:

    1. Paste the formula from above into where you create calculated metrics
    2. Access the ticket fields endpoint from the API: your-subdomain.zendesk.com/api/v2/ticket_fields.json
    3. Find the ticket field (you can search for the name of the field)
    4. Paste the value from the title property into the field name in the formula
    5. Paste the values of the value properties for the previous and new values into the formula

    I hope this helps :)

    0
  • Jessica Strozyk
    Comment actions Permalink

    Thank you so much! I had tried ID and name before, but not value. I am still quite new to zendesk, so I'm only starting to understand its quirks.

    0
  • Marie-Cathrine Sørensen
    Comment actions Permalink

    You're welcome, glad I could help :) 

    1

Please sign in to leave a comment.

Powered by Zendesk