Having an issue with the TOP/BTTM metric. I have set these up before with no issue, no having a problem When I don't have it, it shows a lot, but when top 10 it only shows 2.

Hi Doug, from the second screenshot, I see the insight is using a filter for "Topic", whereas the insight in the first screenshot does not. I would start by making sure that the filter/filter values on both insights are the same if you want to get the same amount of values for top/bottom; I would also recommend creating a metric directly with the TOP clause depending on the logic you are looking for as this allows more flexibility, for example:

SELECT {metric/no_of_tickets} WHERE TOP(5) IN (SELECT {metric/no_of_tickets} 2 BY {attribute/assignee}) WITHIN ({attribute/ticket_group}, all other)

@Moises Morales The filter difference is not the issue, remove or keep its still ALL and 2. Why isn't it working?

Thanks for the details. Can you please share how you defined the metric in the insight where the top 10 shows all the 10 values? Is it a simple count? Are you using the same attribute? If you could share it internally as well that would be great.

its a simple count, i sent you a link