Creating a top/bottom filter

Return to top
Have more questions? Submit a request

6 Comments

  • Violeta Micu

    Hello,

    I have 2 attributes (custom fields) that i use to set the ticket tipology. One is called category and one subcategory

    I need to create a report that will show a TOP 3 Category and a TOP 3 Subcategory for each of the 3 categories.

    Is there a way to achieve this with Explore? In Insights i could create it.

    Thanks :)

    0
  • Graeme Carmichael
    Community Moderator

    Violeta

    It sounds like you should go to Result Manipulation>Top/ bottom

    That may get you close.

    0
  • Idit Matas

    Hi!

    I wanted to check if there is a way in Explore to filter out the 5% of abnormal tickets (for example, the top 5% of tickets that took the longest time to resolve), and look only at the majority of 95% of "normal" tickets.
    I am aware I can use Median, but that wouldn't work if I want to gauge the SUM of the amount of time invested in resolving the tickets, for example.

    Thanks!

    0
  • Graeme Carmichael
    Community Moderator

    Idit

    There is a percentile function that you can apply on your results.

    So you can have a metric SUM(Full resolution time (mins)) in your query.

    Then go to Result Path Calculation and replace this with:

    • Pattern>Percentile
    • Path> On Rows

    I do not know of a way to then filter your output based on this new percentile metric, but you can use the column heading to sort the result from high to low and then make a decision on the items to exclude.

     

    0
  • Idit Matas

    Hi Graeme,

    Thank you for your response!

    Looking into Result manipulation menu, I found the Metric filter option: 

    What I am looking for is this exact functionality, but to filter on percentile and not on absolute values.

    Any chance Explore has this functionality or is planning to add it as part of the roadmap?

    Thank you! Idit

    0
  • Graeme Carmichael
    Community Moderator

    Idit

    Just below the Metric Filter, you should find 'Result Path Calculation'

    That is the one you are after.

    0

Please sign in to leave a comment.

Powered by Zendesk