Report with Description Contains Words ....


  • Graeme Carmichael
    Comment actions Permalink


    Unfortunately the ticket description is not part of Insights, but you can test for text in the ticket subject.

    Create a new custom metric as part of your WHAT section:

    You will find the ' Ticket Subject [Ticket Subject] ' under 'Attribute Labels' in the element selector.

    The ILIKE operator checks for a text pattern with the percentage sign as a wildcard. So any text in the subject matching "Quickbooks" in any case.



  • Eric Norris
    Comment actions Permalink

    That looks like what I want, that's awesome. I'll give it a try, thanks!

  • james
    Comment actions Permalink



    Is there a way to pull all tickets with their subject title containing at least one of the words from a given list? I.e. If I want to pull all tickets that contain either "hello","world", or "turtle", how do I add multiple parameters within the custom metric?



  • Graeme Carmichael
    Comment actions Permalink


    Yes, you can pull multiple items into one metric by using an OR between your conditions:


Please sign in to leave a comment.

Powered by Zendesk