Creating queries

Return to top
Have more questions? Submit a request

12 Comments

  • Kristie

    Is it possible to create a non-numeric query?

    I'd like to create a wordcloud to see the most common words written in or the most common ticket tags used. But it seems that I can only create numeric queries?

    Thank you.

    0
  • Rob Stack
    Zendesk Documentation Team

    Hi Kristie, if you add COUNT(Tickets) to the Metrics panel and Ticket Tags to the Columns panel, then set the visualization to Word Cloud, that should give you the results you want. Hope this helps.

    0
  • Kristie

    Thanks, Rob! That got me what I wanted.

    1
  • Ryan Boyer

    Is there a way to create a query using metrics from two different datasets? For example, if I wanted to create a query for tickets with Knowledge Capture activity (Guide dataset) compared to total tickets created (Support dataset).

    0
  • Rob Stack
    Zendesk Documentation Team

    Hi Ryan Boyer, this isn't currently possible. You can combine queries that were created from different datasets on the same dashboard though I realize that isn't quite what you're looking for.

    I'd encourage you to add this to our product feedback section at https://support.zendesk.com/hc/en-us/community/topics/360001200913 Here, the product team will get to see it and other people can vote the suggestion up or down.

    Thanks for the feedback!

    0
  • Ryan Boyer

    Rob Stack Thanks for the response! I'll leave it in the product feedback section.

    0
  • Laura Mirto

    Is there a way to create a query with how long the article views were? 

     

    0
  • Rob Stack
    Zendesk Documentation Team

    Hi Laura Mirto, that's not currently possible with Explore, but you might be able to use Google Analytics to get a reasonable approximation of this.

    It's also a great suggestion to add to our product feedback section (see link in the post above).

    Thanks!

    0
  • Melody Quinn

    Is there a way to build a query of the number of end-users at a specific date? I can see a count of users under People, but I can not choose a date. Example: I want to know how many end-users we had on May 1st. I pulled a report for user data to use the created date, however, the number of users currently is a few hundred off from the count under People, so now I do not trust the report. 

    Any ideas?

    0
  • Cheeny Aban
    Zendesk Customer Advocate

    Hi Melody,

    Are you trying to create a query to show the number of end-users created on your account or the number of end-user tickets created for a specific date?

    Unfortunately, there is no native way to capture the number of end-users created iin Explore. However, if you would like to capture the end-user created tickets, you can use the recipe: Explore recipe: Reporting on created and solved tickets and use the filter>ticket requester and requested date to see the list of end-users

    All the best

     

    0
  • Melody Quinn

    hi Cheeny Aban, I was looking for the total number of end-users, completely independent of the ticket data. As we are growing our self-service support, it is important for us to know the number of new end-user accounts each month. 

    0
  • Cheeny Aban
    Zendesk Customer Advocate

    Hi Melody,

    The possible workaround is to use the Filter: Requester Created - Date on your report, so you can view the list of created users on a specific date. 

    We understand your need for this functionality so I am marking this conversation as Product Feedback. We truly value customer feedback and your voice and votes in the forums help influence future Zendesk functionality.

     

    0

Please sign in to leave a comment.

Powered by Zendesk