I have a few pie charts that show tickets that are breached by other teams. I was asked by leadership to show only the top 5 groups that breach tickets.
The legend for my pie chart shows Breached Groups (e.g. Helpdesk, Procurement, etc) and the values of the pie chart has a Whole Number count of all of this tickets that are breached (this is from the count column in my dataset). I use Top N for the Breached Groups filter and I get the percent the 5 groups, I need the top 5 groups of the entire data set. Any ideas on how to achieve this?