Explore recipe: Finding tickets with a specific word in the subject

Return to top


  • Dominic Brasoveanu

    Hi all,

    First off, thank you for this article, very cool!

    I realise this a year later, but I'm wondering if anyone can help me.

    I am trying to count tickets that haver certain keywords or strings in the subject line. If I create the attribute as per above, it always shows me "Has this word" "Does not have this word",

    If I just use a simple

    CONTAINS(LOWERCASE([Ticket subject]),"booking failure") then it still gives a TRUE = has keyword, FALSE = these tickets don't have this keyword.

    I have to report on dozens of keywords in the subject line and would ideally like to put these in a table, but the TRUE/FALSE is messing up my table.
    How can I just say IF this ticket contains keyword, show the number of those tickets.
    I have went ahead and created a standard metric instead of the attribute, but now it shows me the tickets in a column and since I need to add dozens, they will not fit. Please see below.
    I do realise I need to make this more efficient and not rely on subject line, I am working on it, but I need to still report on the tickets in the system with certain subject lines.
  • Chandra Robrock
    Community Moderator
    Most Helpful - 2021

    @... You should be able to display the Metrics as a Row by clicking into Chart Configuration on the right-side menu and then Columns. When you have a Table visualization selected, you should see a checkbox to select next to the 'Metric on Rows' option. 

  • Dominic Brasoveanu

    @..., many thanks! That helps a lot.

  • Dominic Jodoin

    Thanks for the great tutorial! I was wondering if it's possible to do something similar but instead of looking for keywords in a Ticket's subject, I would like to look for a string in any of the comments (i.e. public or private) on a ticket. For example, I would like to report on the number of tickets containing a link to our documentation site. Thanks!

  • Rob Stack
    Zendesk Documentation Team

    Hi Dominic Jodoin, what you are looking for isn't currently possible, but it would indeed make a great feature. Can I suggest you add this to our feature requests section at https://support.zendesk.com/hc/en-us/community/topics/1260801325209

    That will bring it to the attention of the product team and enable other customers to vote for it. Thanks!


Please sign in to leave a comment.

Powered by Zendesk