Recreating native ticket metrics with Insights event data Follow



  • Avatar
    Erik Bailey

    Everything here works great, but I wasn't able to find a way to do the final WHERE clause like:

    WHERE Ticket Status IN (Solved, Closed

    How do you get the "Solved" and "Closed" to appear by themselves, rather than [Status] solved?

  • Avatar
    Amy Dee

    Hi Erik! It sounds like you're looking under [Text Field] New Value or [Text Field] Previous Value. Instead, go to Attribute Values, then look under Ticket Status. That should show you the available values for the Ticket Status attribute, including Solved and Closed.

    I hope this helps! Happy reporting!

  • Avatar
    Erik Bailey

    Score - that was it! Thank you! :)

Please sign in to leave a comment.

Powered by Zendesk