Show Top 10 Results and group the rest

3 Comments

  • Hillary Latham
    Community Moderator

    You could show source as an attribute in your query, choose a metric of Tickets with a Count aggrigator, then use results manipulation to sort descending on count and limit the list to 10.

    0
  • James Pellizzi

    Right, but that doesn't fulfill the "grouping the rest" part. I need a way to either group everyone outside of the top 10 or display the total count.

    Ex - Let say I wanted the top 3 companies creating support requests and then group the rest.

    Org A -100 requests
    Org D - 75 requests
    Org Z - 50 requests
    -then I have 20 other orgs, with less than 50 each, but combined they are 200 (ex 10 each)

    Id want to bucket the other 20, or at least display the sum of their tickets. I'd even accept a way of showing the top 3 orgs created 225 tickets of the 425 total tickets.

    Does this make sense?

     

    0
  • Hillary Latham
    Community Moderator

    Hey James - I missed the grouping detail in your original question.  I don't know of a way to do this in a single query in Explore.  If you had a good idea of what your top 10 normally is (if it doesn't change much), you could create a group attribute - have all the top 10 (or top 15) items be specific in the group then all other categories be in an "other" group.  Then you can just report on the counts by that grouped attribute. 

    My only other thought is some combination of custom attributes or metrics - but off the top of my head, I'm not sure what that might look like.

    0

Please sign in to leave a comment.

Powered by Zendesk