Choosing metric aggregators

Have more questions? Submit a request

10 Comments

  • Chris Wooten
    Comment actions Permalink

    I am new to this Software but have been using Power BI for years. I am not sure why the program will not allow me to make averages of simple metrics such as the number of tickets solved per person.

     

    0
  • Rob Stack
    Comment actions Permalink

    Hi Chris, I'm sorry for the late response.

    One way you could do this is (using the Tickets dataset) to add the metric SUM(Tickets solved - Daily average), and then add Assignee name to the Rows panel.

    I hope this helps,

    0
  • Job Thomas
    Comment actions Permalink

    How can I rather than looking at the MED look at the 90% percentile for example? In our case, that's a lot more telling than the MED and it's much more the metric we would want to check.

    2
  • Alex Engel
    Comment actions Permalink

    Does SUM() round up to the nearest integer? One metric of ours is supposed to be 9.5 but instead displays 10.

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Alex,

    I confirmed with one of our Explore experts and it looks like most aggregators would round up to the nearest integer by default. If this isn't the desired result for you, you'll want to manually change the decimals places via the Chart Configuration>Display format

    Let me know if you have any other questions :)

    0
  • Pierce Benlian
    Comment actions Permalink

    I'm trying to count inbound calls but my COUNT and D_COUNT values are different for the same calls. I see inbound calls with 1 ticket number counting as 2 when I pull COUNT but 1 when I use D_COUNT.

    What action is being applied to cause a value of 2 to be given in COUNT?

    0
  • Devan - Community Manager
    Comment actions Permalink

    Hello Pierce Benlian,

    So when you use COUNT, this will show up as two calls because sometimes there can be two or more calls attached to a ticket. I would recommend using D_COUNT for your reporting if you are looking to report on just the number of tickets with calls. If you feel though that this is incorrect and possibly a bug, let us know, and we'll investigate this further for you.

    Best regards. 

    0
  • Alessandro Bertuci
    Comment actions Permalink

    How can we customize the count to use the 75th or 90th percentile to measure First Response Time?

    0
  • Devan - Community Manager
    Comment actions Permalink

    Alessandro Bertuci,

    We would love to answer this question for you but we could use a little more information on what you're trying to accomplish. I would also recommend posting your question in our Explore AMA topic so our experts can reply to you with their solution. I've included a link below where you should post your response. 

    Explore AMA 

    Best regards. 

    0
  • Devan - Community Manager
    Comment actions Permalink

    On Wednesday, April 8, from 8:00am-10:00pm CDT, we'll have a special guest team of experts on hand to answer your questions about Explore: Reporting & Insights Migration in your Zendesk Explore instance for an AMA-style conversation!

    Just click the "new post" button and write up your question. Be sure to be as detailed as possible. The best questions include: 

    • What it is you're trying to do
    • What you've tried so far 
    • Any other context or relevant information
    • Screenshots, if you have them

    Questions posted to this topic in advance of the start time will be answered first thing on the 8th, so if you've got something you want our experts to look at, post it today!

    0

Please sign in to leave a comment.

Powered by Zendesk