Performance Analytics - Top 10 customers

[Community Alums]

Hello!

I am trying to create a visualization that shows the top 10 customers either for case or incident (top 10 requested_for).  When I create the PA, the breakdown has too many entries so it fails to run, even if I max out the results to 10 on the visualization.  Is there a way to limit the breakdown to creating 10 buckets so that it can still display?

My guess is that this needs to be a script that can place the results into a bucket group that is labeled 1-10, but that will not show the name of the customer, just the manual bucket name provided. I'd ideally like a way to show the names of the top 10 customers, then be able to click to see their records. I've been looking through the indicators and breakdowns that come out of the box but I have not found something similar to what I am looking for. I feel like this would be a common enough request from a manager that there has to be a way to accomplish this using PA. 

Thank you!

[Uncle Rob]

I wish there was a beautiful solution for TopX reports, but it always ends up being difficult.

Even your scripted bucket values is going to have problems, because it will grow beyond 10 entries every time a new group breaches the top10.  To sustain historic values, it won't delete old bucket values.  
This will also make it harder to track the top10 over time... because my Top10 today might be different from yesterday.  Thus which buckets would show if I was graphing them over a week?

[valesky]

Hello did you find a solution for this requirement?