Explore recipe: Tickets by agent by channel

Have more questions? Submit a request

6 Comments

  • Ed Soria
    Comment actions Permalink

    Nice work,

    I noticed that by default, Explore only selects one value per row so if you want to see the stacked chart as expected, you need to select all or at least multiple values in the row. (In this case, multiple channels)

    This first example is configured for a stacked chart but only one channel is selected. 

    This example has all channels selected and now you see the stacked chart displayed:

    0
  • Rob Stack
    Comment actions Permalink

    Nice tip, thanks Ed!

    0
  • CIT Aspial
    Comment actions Permalink

    How to sort the results of the stacked bar?

    0
  • Marj
    Comment actions Permalink

    Hi CIT Aspial,

    Hope you're having a great day!

    With regards to your concern about sorting stacked bar results, you can do this by selecting the result manipulation menu on the right side when creating/editing query, then select Sort. 

     

     

    For more information with regards to sorting results in Explore, please refer to this article, https://explore.zendesk.com/hc/en-us/articles/235944108-Sorting-results 

     

    Cheers!

    0
  • Sharin Kaur
    Comment actions Permalink

    Hi there,

    We're not using Channels however we are using Forms or Priority. If I were to try and create this for Priority - I'm taking a look at Count Tickets, Assignee Name, but in Rows input "Priority" and then create a Time Filter by Month (Time Created>Date Range>Simple> Current Month), will this show me All tickets "open" this month? I'm just not sure what "status" of the ticket this is - "the number of tickets in your account" are these open/solved/pending/created this month? What is the value "tickets>tickets"? 

    Is this "all tickets assigned this month by priority"? What I am trying to do is see distribution per month of tickets by priority. Is this showing all tickets assigned regardless of status? 

    0
  • Devan
    Comment actions Permalink

    Hello Sharin Kaur,

    After looking over your post and report, I would recommend following the explore recipe I've linked below that goes into detail on reporting on the status of all tickets within the last 30 days. This should give you the breakdown of tickets still open within a said month. 

    Explore recipe: Daily ticket activity in the last 30 days

    Best regards. 

    0

Please sign in to leave a comment.

Powered by Zendesk