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

Have more questions? Submit a request

15 Comments

  • Jesse Asklund
    Comment actions Permalink

    Eric Gao I do not believe this recipe is accurate anymore. On step 11 (From the list of attributes, choose Calculated attributes > Contains), Rows does not have a "Calculated attributes" section to choose the new calculated attribute. The only area I saw the one I created was in "Metrics" but that's not the right section for that.

    Is there a new way to get this metric?

    0
  • Eric Gao
    Comment actions Permalink

    Hi Jesse,

    Once you have created the Standard Calculated Attribute as instructed in the recipe, you will see the "Calculated attributes" section under Rows:

    Note - make sure that in Step 4 you are creating an attribute rather than a metric.

    Thanks,

    Eric

    1
  • Jesse Asklund
    Comment actions Permalink

    Eric Gao

    Good call! I did metric instead of attribute. Thanks for that.

    I notice there's some broken images on the guide as well you may want to look at.

    Thanks!

    1
  • Rob Stack
    Comment actions Permalink

    Hi Jesse Asklund

    Thank you for spotting the broken images! - These are now fixed.

    1
  • Bart
    Comment actions Permalink

    Eric Gao

     

    Is it possible to do the same, but for a word in the ticket description, but split by end user vs agent / admin? 

     

    I guess I could use the data filter user role for splitting by agent / end user. 

    I am however looking at matching search strings from the HC - with tickets coming in. 

    Any ideas would be great. 

    Thanks
    Bart

    0
  • Devan
    Comment actions Permalink

    Hello Bart,

    Yes, this is possible by replacing ticket subject with ticket description in the recipe above then adding user role to the rows above the newly created attribute. Let us know if you run into any issues setting this up, and we'll be happy to help. 

    Best regards. 

    0
  • Bart
    Comment actions Permalink

    Heya Devan

    Tried replacing subject with description and I don't get the description option. Am I missing something?

    0
  • Kaylee
    Comment actions Permalink

    Hello! This is a really helpful article. With subject lines being very long, variable etc, is there a way to capture multiple words in the subject (a string and multiple individual words)? When I add individual custom attributes for each individual term and then add them each as a row, the "has this word" and "Does not have this word" get wonky. See screenshot and then the count of tickets is out to the right of these two columns. The example in the article has nice columns but I also don't see a common word among all of the subjects so I am wondering how that works?

     

    If I want to see the number of tickets that have the following words in their subjects in one single chart, how would I accomplish that? 

    -edge

    -machine

    -jobs

     

    -etc... 

    0
  • Rob Stack
    Comment actions Permalink

    Hi Kaylee thanks for asking this question. I did some experiments and made it work like this:

    I created an attribute to look for both of the words "shipping" and "returns" in the ticket subject. It looks like this:

    You'll see from my results that this gives the required result:

    You can add as many AND lines to the formula as you need. I hope this helps!

    0
  • Kaylee
    Comment actions Permalink

    Thank you! I am curious if OR lines work the same way. Going to play with that now. 

    0
  • Rob Stack
    Comment actions Permalink

    Thanks Kaylee let us know how that goes. I think it should work just fine.
    I've added this recipe to the queue to do a couple of updates based on our discussions :-)

     

    0
  • Kaylee
    Comment actions Permalink

    That's great! I havent been able to get this to work on my end (even with AND). Are you able to jump into email or on a call so I can share more specific information?

    0
  • Rob Stack
    Comment actions Permalink

    Hi Kaylee I've created a ticket based on your request so that one of the support team can work with you directly to get this working. You'll hear from someone soon. I hope this helps!

    0
  • Kyle Crouthamel
    Comment actions Permalink

    Devan Chandler checking back in on the query with description issue that Bart is seeing https://support.zendesk.com/hc/en-us/articles/360041681533/comments/360004551034

    Any way to query description/comments? Tried to change the calculation formula but not able to find ticket description.

    0
  • Eric Gao
    Comment actions Permalink

    Hi Kyle - Explore currently cannot report on Ticket Comments or Ticket Description. We recommend checking out the Explore reference for a complete list of available metrics and attributes.

    The good news is that it has been listed as a potential item on our future roadmap (timeline TBD) to have the ticket description available in our datasets.

    1

Please sign in to leave a comment.

Powered by Zendesk