Show Top 10 Results and group the rest
AnsweredHi All,
Been trying to show the top 10 sources of tickets in a pie chart (or any chart for that matter) and then group the rest. I've tried a variety of manipulations/calculations, but so far - no dice.
Is this even possible through the platform? Any guidance would be appreciated.
Thank you.
-
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.
-
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? -
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.
Please sign in to leave a comment.
3 Comments